Hi. I'm using MS XP (Home) and MS Excel 2003, and I'm just learning how to
use the program, so please bear with me (what follows below is a little
long-winded). I recently imported a very large Access database file into
Excel. This file has five columns, and one of them is a KeyID column
(numbering 1 to 60,000). I will be sorting this Excel Sheet frequently, but
I need to maintain the exact (original) order of the file for reasons I won't
go into here. I will sort the Sheet, make some changes, then sort on the
KeyID column to return to the original order (which starts at 1).

The tops of the columns are, of course, A, B, etc. Then there is a blank
row, and below this are the former Access headings (which appeared when I cut
and pasted into the Excel Sheet), so the file looks something like this:

A, B, C, D, E, etc.
(blank row here)
A, B, C, D, KeyID (which contains numbers, of course).

After the KeyID I will insert into a new column an English translation of
the Korean words in B and D columns (this new column is labeled "TRA"). Now
as I mentioned when I asked a similar question before, I am very worried
about having the original order disrupted because occasionally I will have to
add new rows and then renumber the KeyID column, which one of the MVPs so
kindly helped me do. My problem is this: I have been experimenting with the
sorting just to see if the order is being maintained, but one time the blank
line at the top disappeared and one of the rows down below ended up at the
top and stayed there, thereby disrupting the original order (I guess it
became a heading or something). Do you follow me here? I'm sorry about
being so windy in my explaination, but I can't show you a picture. Could
someone please give me (or direct me to) some advice or detained information
about sorting in Excel so as to maintain the original order at all times
(just as when I used Access). Thanks.