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
|