Copying formulas to end of Column

K

kippers

Hi,

Quick question- how can I quickly copy a formula to the end of an entire
column (without having to scroll all the way down)??

Cheers,
 
P

pinmaster

Hi,

Try this:

select the cell you wish to copy down then hold the Shift+Ctrl and hit the
down arrow key to select the rest of the column, next hit the F2 key to go
into the edit mode then hold the Ctrl key and hit Enter.

HTH
Jean-Guy
 
G

Gord Dibben

Do you really want a formula that extends to row 65536(entire column)?

Is the formula in a column adjacent to a column with data?

If so, double-click on the fill handle of the cell with the formula to fill down
to bottom of data in adjacent column.


Gord Dibben MS Excel MVP
 
Top