Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you! By the way I thought I knew what a cell handle was but double
clicking didn't do anything. I think I understand what was intended to happen. -- Marie "Shane Devenshire" wrote: Hi, Here is a quick way to add a default sort order column: Insert a new column, suppose its to the left of your data, Column A. In cell A2 (assuming you have titles on row 1) enter 1 and in cell A3 enter 2. Select both cells and double-click the fill handle. This will work if there is data in all the cells in column B (the original column A). This will create a column of numbers which you can later sort on to return you to the default order. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Marie Robinson" wrote: I sorted my nearly 7,000 entries to add a detail in one column and saved the addition. How do I return to the original data-entry order and keep that as the default order? -- Marie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i remove sort and see the original order of the data? | Excel Discussion (Misc queries) | |||
how to restore the original data order | Excel Discussion (Misc queries) | |||
trace order of data entry | New Users to Excel | |||
Sort Data Into Numerical Order..! | Excel Discussion (Misc queries) | |||
Sort data into order of product | Excel Discussion (Misc queries) |