Numbering items in Excel

  • Thread starter Thread starter Paul Tiwana
  • Start date Start date
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

(e-mail address removed)
 
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
--
 
Back
Top