Greetings. I am using Excel 2007 (beta) and I have a very large spreadsheet
(455896 rows!) that consists of five columns (with each row in the first four
columns filled in with various data). Of course, I back up the file daily,
and I am well aware of the risks of using a beta, but so far it seems very
stable (knock on wood). The reason I am using Excel 2007 is that it has
expanded capacities (e.g., in the number of rows). The various rows in the
fifth column will be filled in as time goes on (after certain sorts and
resorts, for example).

I want to sort and resort on certain columns occasionally, but I want to
strictly maintain the original order in each of the rows in all of the
columns (I realize this could be done in MS Access, but I have my reasons for
sorting and resorting in Excel). First, I guess I'll have to make a numbered
"key" column (ala Access) in the fifth column to enable a resort to the
original order. Could you please give me some advice on how I can sort and
then resort into the original order? To repeat, it is absolutely essential
to maintain the original order of rows and the five columns.