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

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

Thanks--what a relief to have this info now!
--
Marie


"Dave Peterson" wrote:

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

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

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

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

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

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