Tech Support Guy banner
Status
Not open for further replies.

Sequential numbers in Excel

2K views 6 replies 3 participants last post by  maxib 
#1 ·
I'm doing quite a long spreadsheet in Excel and need to number each row sequentially. I know there used to be a way to do this but maybe it was in an older version of Excel. I'm currently using Excel 2002. I tried using a forumla to add one to the row number above but realized when I sort the sheet by a different column, the row number changes. If anyone can tell me how I can number the rows without having to hand type each number, I would appreciate it.
 
#4 ·
MFDnSC said:
Type 1 in the first row and drag it down, if that doesn't get it type 1 then 2 in the next and drag down
This is what I thought I had done before but I've tried it again and again and can't get it to work. Either it does nothing or it copies the 1 and 2 to the bottom of the column. Any suggestions?
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top