Copying formulas to end of Column
 

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,

Copying formulas to end of Column
 

CTRL+C
Down Arrow
Press and hold Shift
End
Down Arrow
Release Shift
Ctrl+V

Steve



On Wed, 31 Jan 2007 16:59:01 -0000, kippers
wrote:

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,

Copying formulas to end of Column
 

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

"kippers" wrote:

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,

Copying formulas to end of Column
 

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

On Wed, 31 Jan 2007 08:59:01 -0800, kippers
wrote:

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,