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,