| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Is there a quick way to number rows? I have 43,000 records and I need to do
a sort and update, but then I need to take my data back to the way it was in the beginning. I thought if I added a column named numbered and numbered all the way down, then I sort and make my changes several times, then before I saved the file, I could sort the numbered column in ascending order, delete this column and now save it as it was in the beginning. The only way I know how to number is type 1, 2 and then select these two and drag all the way down, but I am talking 43,000 rows. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Cells with same number in three rows then skip to next number | Excel Worksheet Functions | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Threaded Mode
