Fill to Bottm of Sheet

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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
 
In cell A1 enter
=ROW()

Copy cell A1. Select Column A. Right click>Pastespecial>Formulas..Click OK


If this post helps click Yes
 
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 Edit>Copy
Then Edit>Paste Special>Values>OK

Another way...

Enter 1 in A1
Selet the entire column
Goto Edit>Fill>Series
Stop value = 65536 (or whatever you want)
OK
 
Back
Top