Very basic query

  • Thread starter Thread starter KiwiBrian
  • Start date Start date
K

KiwiBrian

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
 
Select B2 again, press F5, type in B3005, hold down shift key and press enter,
press ctrl + d


Regards,

Peo Sjoblom
 
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
 
D-Click will work only if there is data down to row 3005 in an adjacent
column.

Gord Dibben Excel MVP
 
Thanks everyone you have helped mightily.
Brian.

Gord Dibben said:
D-Click will work only if there is data down to row 3005 in an adjacent
column.

Gord Dibben Excel MVP
Click to expand...
 
Back
Top