how do I automatically add row numbers in column

  • Thread starter Thread starter Guest
  • Start date Start date
Do you want the row numbers in column A? Insert a column, enter 1 in A1,
then click on the lower right part of the cell, and drag it down. This is
probably the easiest way to do this.

Carole O
 
ceegar wrote:

did you see the answer from JE McGimpsey in the other thread you started?

one way:

A1: =ROW()

Copy down as far as necessary.



Another way is 1 in A1 2 in A2 highlight both cells then drag
it from the right hand corner down the column.

gls858
 
Carole

With a 1 only in A1 you cannot drag/copy down using left mouse button or you
will get all 1's as you have discovered.

With a 1 in A1, RIGHT-click and drag down. Release button and select "fill
series" from the menu that pops up.

Best to go with JE's advice with the =ROW()

If you delete a row, you don't have to make any alterations.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count number of text rows??? 3
Excel Add rows automatically in excel 3
How do number columns first, then the rows in an excel footer? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
row numbers in column 1
How do I add 1 to a number in column b 8
How do I number sequentially omiting the headings in excel? 2
how do I get a new row to add to a column automatically? 14

Back
Top