Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I automatically add row numbers in column
|
#2
|
|||
|
|||
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: |
#3
|
|||
|
|||
When I do that, I get '1' in lots of rows...
Carole D "Carole O" wrote: 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: |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 On Tue, 26 Apr 2005 14:50:04 -0700, Carole Drake wrote: When I do that, I get '1' in lots of rows... Carole D "Carole O" wrote: 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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
add only positive numbers and avg in a column | Excel Worksheet Functions | |||
I need to find odd numbers in a column | Excel Worksheet Functions | |||
How do I format a column to automatically make it a negative numbe | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |