Numbering items in Excel

P

Paul Tiwana

I hv put few items in Excel rows.
I want to put serial numbers on items like 1,2,3, 4 on each row.
Is there a command which numbers the items serial wise.
When I print them , item number should appear number wise.

Plz advise

[email protected]
 
D

David McRitchie

Hi Paul,
You can use the fill handle to fill down a constant (like 1)
http://www.mvps.org/dmcritchie/excel/fillhand.htm

But if you want the numbers to change when you sort you
might use something relative to the current row number.
Select A2 and drag the fill handle down. Double-click the
fill handle will be faster if you have something to the left
or if nothing on the left will check to the right.

A1: 'item
A2: =ROW()-1
--
 
Top