infinity and beyond

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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

 

[Chip Pearson]

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

message
news:[email protected]...