View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Marie Robinson Marie Robinson is offline
external usenet poster
 
Posts: 12
Default Original Sort/Data Entry Order

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