Just curious, why do you need to sort the spreadsheet before making
updates? Can't you make the updates without sorting it first? Then you
wouldn't have the problem of needing to sort it back to the way it
was.

If you want to preserve a list of data so you can sort it and then re-
sort it back to its original sort order, just insert a helper column
(I use column A) and fill down the number series (1,2,3 ....). Sort by
whatver column you want, then when you are done, just sort it by that
column again.

Why are you inserting rows, I thought you wanted to preserve the
original sort order. Can't you just append the new data to the bottom?
Otherwise, just insert your rows, then recreate the number series.

HTH,
JP

On Sep 21, 12:34*am, Rebecca
wrote:
Greetings. I am using MS VISTA and Excel 2007 (I am a relative newcomer).

I was wondering if I can create a (Primary) Key column (or whatever it's
called), so that I can resort the spreadsheet back to the original order /
sequence (that is, after I make some revisions / updates in certain cells).

The problem arises when I have to insert new rows, which create gaps in the
column I am currently using (it is simply a column with a numbered sequence
1-about 700000!). *How can this be done? And please explain in very simple
English. Thank you.