I want to sequentially fill a column to the end of the sheet, (65,XXX rows).
Is there an easier way than manually dragging all the way to the end?

hi
in the desired column row 1, enter a 1(one). lets say A column.
in row 2 (same column) enter = A1+1.
Copy the formula in A2.
hold down the shift key and press end key then down key.
paste.
copy column A then paste special Values.

Done.
Regards
FSt1


"Ed" wrote:

I want to sequentially fill a column to the end of the sheet, (65,XXX rows).
Is there an easier way than manually dragging all the way to the end?

In cell A1 enter
=ROW()

Copy cell A1. Select Column A. Right clickPastespecialFormulas..Click OK


If this post helps click Yes
---------------
Jacob Skaria


"Ed" wrote:

I want to sequentially fill a column to the end of the sheet, (65,XXX rows).
Is there an easier way than manually dragging all the way to the end?

What sequence do you want to fill? 1,2,3,4,5 etc.?

One way...

Select the entire column by clicking on the column header.

Type this formula: =ROW()
Then, instead of hitting the Enter key like you normally would, hold down
the CTRL key then hit Enter.

Now, convert the formulas to constants...

With the entire column still selected
Goto EditCopy
Then EditPaste SpecialValuesOK

Another way...

Enter 1 in A1
Selet the entire column
Goto EditFillSeries
Stop value = 65536 (or whatever you want)
OK

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
I want to sequentially fill a column to the end of the sheet, (65,XXX
rows).
Is there an easier way than manually dragging all the way to the end?