Thank you David and Shane. Shane's method worked the best. Since the row
numbers were not as a result of a formula, the numbers didn't change to match
the new row numbers caused by the sorting. In other words using the formula
method allowed the new column of row numbers to change depending on their new
position in the sorted chart.

Thanks again everyone!
--
Marie


"David Biddulph" wrote:

The fill handle is in the bottom right-hand corner of the cell. Select the
cell, then move the cursor over the black square in the bottom right-hand
corner, and the cursor turns to a thin black plus instead of the normal
thick white one.
--
David Biddulph

Marie Robinson wrote:
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.

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