copy formula down a whole column?

[Steve Hawkins]

I probably ought to know this, but:

How can I copy a formula that will increment as necessary (A2, A3, A4 etc)
down a whole column. Currently I am dragging the corner down so far and
then having to remember how far I've gone. How should I really be doing it
folks?

Be gentle,

Steve_H

 

[Pete_UK]

If you have data in an adjacent column, then you can just double-click
the fill handle on the cursor. This is the small black square in the
bottom right corner, and it will fill down for as many entries as you
have in the column to the left.

Hope this helps.

Pete

 

[Gord Dibben]

In addition to Pete's d-click method...........

Select B1 and enter your formula. Say =A1

Click in namebox and type B1:B234 and ENTER

Hit CTRL + D to increment down to B234


Gord Dibben MS Excel MVP

 

[Steve Hawkins]

Instead of having to specify a row number, is there not a way to specify
the whole column i.e. 'B1:B'infinity'' in your example? It is rather odd to
me that when one applies column borders they go to infinity, but there seems
to be no obvious way for the 'formulas to go along with them'.

Thanks for the suggestions all the same,

Steve_H

 

[Peo Sjoblom]

Just click the column header for B:B or from a particular cell do ctrl +
shift and down arrow

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Steve Hawkins]

Thanks Peo,

I thought it should be that simple!
In my case, however, it turns out to be Ctrl D, rather than Ctrl 'down
arrow'.

Glad I wasn't the only one who hadn't realised this!

Regards,

Steve_H