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.
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?
Okay, that worked! I wasn't gragging the corner. Thanks SO much.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!