How do I consecutively number my 512 cells all at once, not one square at a time?

[SkyWalkerIV]

I would like to consecutively number all the cells at once, not one at a time

[anon73440385]

Hello,

assuming you want number cells A1:A512 from 1 through 512

Method 1

• Type 1 into cell A1
• Drag down on the square on the right lower corner of the cell to A512 ( mouse pointer changes to + - like symbol)

Method 2

• Type 1 into A1

• Set =A1+1 into cell A2

• Copy A2 (CTRL+C)

• Insert text A2:A512 into the Name Box leftmost of formula bar and press ENTER (Range gets selected)

• Paste using CTRL+V

Method 3

• Type 1 into A1

• Set =A1+1 into cell A2

• Insert text A2:A512 into the Name Box leftmost of formula bar and press ENTER (Range gets selected)

• Type CTRL+D (equivalent to Sheet -> Fill Cells -> Fill Down)

Method 4

• Insert =ROW() into cell A1

• Copy A1 (CTRL+C)

• Insert text A1:A512 into the Name Box leftmost of formula bar (Rang gets selected)

• Paste using CTRL+V

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

[mikekaganski]

Method 5: Sheet → Fill Cells → Fill Series

[anon73440385]

searched for that, but forgot that I need to select column first and thus it has been greyed out.
@SkyWalkerIV - stick with method 5 - it is the easiest one