how to increment no on excel spreed sheet
 

f I have one excel spree sheet and I want to add line no on the first
columnA, from 1 to 100, how do I do that?
ColumnA ColumnB
1 abc
2 ddd
3 add
4 eee


thanks.

Lillian

how to increment no on excel spreed sheet
 

Two ways to do that

First method
Enter 1 in A1
Enter =A1+1 in A2
Copy A2 from A3 to A100

Another method
Enter =row() in A1
Copy A1 from A2 to A100

Alok Joshi

"Lillian" wrote:

f I have one excel spree sheet and I want to add line no on the first
columnA, from 1 to 100, how do I do that?
ColumnA ColumnB
1 abc
2 ddd
3 add
4 eee


thanks.

Lillian

how to increment no on excel spreed sheet
 

You could also use the "fill handle":

Enter a "1" in cell A1.
Move your mouse to the bottom right corner of the cell until it changes to a
wide-looking + symbol.
Hold down Ctrl and drag your mouse down for 99 more rows.
Let go. Numbers fill in column A from 1 to 100.
If you don't hold down Ctrl, it copies the identical number 100 times instead.
Holding or not holding Ctrl has the opposite fill effect if your column
contains dates instead of numbers (i.e. you hold down Ctrl to get the SAME
date several times, or don't hold it down to get the natural sequence of
dates in the calendar).

Pretty neat, isn't it?

--
--Draconian


"Alok" wrote:

Two ways to do that

First method
Enter 1 in A1
Enter =A1+1 in A2
Copy A2 from A3 to A100

Another method
Enter =row() in A1
Copy A1 from A2 to A100

Alok Joshi

"Lillian" wrote:

f I have one excel spree sheet and I want to add line no on the first
columnA, from 1 to 100, how do I do that?
ColumnA ColumnB
1 abc
2 ddd
3 add
4 eee


thanks.

Lillian

how to increment no on excel spreed sheet
 

Yes that is another way. Also I did not know about the opposite behavior of
the dates. Thanks.

"Draconian" wrote:

You could also use the "fill handle":

Enter a "1" in cell A1.
Move your mouse to the bottom right corner of the cell until it changes to a
wide-looking + symbol.
Hold down Ctrl and drag your mouse down for 99 more rows.
Let go. Numbers fill in column A from 1 to 100.
If you don't hold down Ctrl, it copies the identical number 100 times instead.
Holding or not holding Ctrl has the opposite fill effect if your column
contains dates instead of numbers (i.e. you hold down Ctrl to get the SAME
date several times, or don't hold it down to get the natural sequence of
dates in the calendar).

Pretty neat, isn't it?

--
--Draconian


"Alok" wrote:

Two ways to do that

First method
Enter 1 in A1
Enter =A1+1 in A2
Copy A2 from A3 to A100

Another method
Enter =row() in A1
Copy A1 from A2 to A100

Alok Joshi

"Lillian" wrote:

f I have one excel spree sheet and I want to add line no on the first
columnA, from 1 to 100, how do I do that?
ColumnA ColumnB
1 abc
2 ddd
3 add
4 eee


thanks.

Lillian