is it possible to copy a formula down a column for as long as the column
exists - ie ALL cells within the column - not just those visible?

thanks again
suzanne

CTRL-SHIFT-DOWN will select all cells from the current cell to the very
bottom (row 65536). So, copy your formula, select the cell below,
Ctrl-Shift-Down, Paste.

HTH,
Elkar


"sedonovan" wrote:

is it possible to copy a formula down a column for as long as the column
exists - ie ALL cells within the column - not just those visible?

thanks again
suzanne

Enter the formula in A1

Click in the Name Box and type A1:A65536 and ENTER

Hit CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Thu, 22 Jun 2006 11:14:02 -0700, sedonovan
wrote:

is it possible to copy a formula down a column for as long as the column
exists - ie ALL cells within the column - not just those visible?

thanks again
suzanne

Select all of column A, for example, by clicking on the column
header. Type your formula and press CTRL+ENTER rather than just
ENTER. This will fill the entire column with the formula, down to
the last row.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"sedonovan" wrote in
message
...
is it possible to copy a formula down a column for as long as
the column
exists - ie ALL cells within the column - not just those
visible?

thanks again
suzanne