| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Very basic query
After entering a formula into a cell, say b2, how do I tell excel to copy
the formula right down to b3005? TIA Brian Tozer |
|
#2
|
|||
|
|||
|
Select B2 again, press F5, type in B3005, hold down shift key and press enter,
press ctrl + d Regards, Peo Sjoblom "KiwiBrian" wrote: After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer |
|
#3
|
|||
|
|||
|
OR
If there is data in all of the associated cells to the formula, just double click on the little black square in the bottom right of B2 HTH Michael "Peo Sjoblom" wrote: Select B2 again, press F5, type in B3005, hold down shift key and press enter, press ctrl + d Regards, Peo Sjoblom "KiwiBrian" wrote: After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer |
|
#4
|
|||
|
|||
|
D-Click will work only if there is data down to row 3005 in an adjacent
column. Gord Dibben Excel MVP On Thu, 23 Dec 2004 14:03:03 -0800, "Michael" wrote: OR If there is data in all of the associated cells to the formula, just double click on the little black square in the bottom right of B2 HTH Michael "Peo Sjoblom" wrote: Select B2 again, press F5, type in B3005, hold down shift key and press enter, press ctrl + d Regards, Peo Sjoblom "KiwiBrian" wrote: After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer |
|
#5
|
|||
|
|||
|
Thanks everyone you have helped mightily.
Brian. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... D-Click will work only if there is data down to row 3005 in an adjacent column. Gord Dibben Excel MVP On Thu, 23 Dec 2004 14:03:03 -0800, "Michael" wrote: OR If there is data in all of the associated cells to the formula, just double click on the little black square in the bottom right of B2 HTH Michael "Peo Sjoblom" wrote: Select B2 again, press F5, type in B3005, hold down shift key and press enter, press ctrl + d Regards, Peo Sjoblom "KiwiBrian" wrote: After entering a formula into a cell, say b2, how do I tell excel to copy the formula right down to b3005? TIA Brian Tozer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query of External Data | Excel Discussion (Misc queries) | |||
| saving wkbk minus MS Query links | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
| New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
