copy formula down a whole column?

S

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
 
P

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
 
G

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
 
S

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
 
Top