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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Enter 1 in row 1, 2 in row 2, select both cells and just drag and copy down.
-- __________________________________ HTH Bob "Pammy" wrote in message ... 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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Try this:
Enter a 1 in your first cell. Make sure that cell is selected From the EDIT Menu, choose "Fill" then "Series" Series in "Rows" Type "Linear" Step Value = 1 Stop Value = 43000 Click OK In Excel 2007, the FILL option would be found in the Editing Section of the Home Tab. HTH Elkar "Pammy" wrote: 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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Sorry, one correction. I meant to say, Series in "Columns" not rows.
"Elkar" wrote: Try this: Enter a 1 in your first cell. Make sure that cell is selected From the EDIT Menu, choose "Fill" then "Series" Series in "Rows" Type "Linear" Step Value = 1 Stop Value = 43000 Click OK In Excel 2007, the FILL option would be found in the Editing Section of the Home Tab. HTH Elkar "Pammy" wrote: 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, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Thank you so much, I have learned something new.
"Elkar" wrote: Sorry, one correction. I meant to say, Series in "Columns" not rows. "Elkar" wrote: Try this: Enter a 1 in your first cell. Make sure that cell is selected From the EDIT Menu, choose "Fill" then "Series" Series in "Rows" Type "Linear" Step Value = 1 Stop Value = 43000 Click OK In Excel 2007, the FILL option would be found in the Editing Section of the Home Tab. HTH Elkar "Pammy" wrote: 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, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Even easier method.
In a column adjacent to your data type a 1 and a 2 then select both those cells and double-click to copy down to end of data. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:18:16 -0700, Pammy wrote: Thank you so much, I have learned something new. "Elkar" wrote: Sorry, one correction. I meant to say, Series in "Columns" not rows. "Elkar" wrote: Try this: Enter a 1 in your first cell. Make sure that cell is selected From the EDIT Menu, choose "Fill" then "Series" Series in "Rows" Type "Linear" Step Value = 1 Stop Value = 43000 Click OK In Excel 2007, the FILL option would be found in the Editing Section of the Home Tab. HTH Elkar "Pammy" wrote: 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, |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Only if there are no gaps!
-- __________________________________ HTH Bob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Even easier method. In a column adjacent to your data type a 1 and a 2 then select both those cells and double-click to copy down to end of data. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 10:18:16 -0700, Pammy wrote: Thank you so much, I have learned something new. "Elkar" wrote: Sorry, one correction. I meant to say, Series in "Columns" not rows. "Elkar" wrote: Try this: Enter a 1 in your first cell. Make sure that cell is selected From the EDIT Menu, choose "Fill" then "Series" Series in "Rows" Type "Linear" Step Value = 1 Stop Value = 43000 Click OK In Excel 2007, the FILL option would be found in the Editing Section of the Home Tab. HTH Elkar "Pammy" wrote: 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, |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
number rows
Good point
Gord On Mon, 9 Mar 2009 18:28:43 -0000, "Bob Phillips" wrote: Only if there are no gaps! |
Reply |
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) |