I did see those steps. I don't know how to 'convert those formulas to
values' but since the formula changed all by itself to the row number, I
assumed that step was automatic. I also didn't know what the second line in
the instruction meant. Will you translate those two steps?
--
Marie


"David Biddulph" wrote:

If Dave Peterson's method didn't work for you, it's presumably because you
missed out the following step from his recommendation:
"convert those formulas to values
Select the range, then edit|copy followed by edit|paste special|values."
--
David Biddulph

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

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