View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Original Sort/Data Entry Order

I use a helper column of cells.

Insert a new column A.
Fill each cell in that column with a formula
=row()
convert those formulas to values
Select the range, then edit|copy followed by edit|paste special|values.

Then sort the data as much as you want (include all the columns).
Make your changes.
And resort the data by that helper column.
Then delete the helper column.



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


--

Dave Peterson