Reverting back to Original Column Sort order

[bearcub]

Is there another way of reverting back to the original column sort order other than adding a helper column with the original sort order (without using VBA, of course)

Jon, from Excel Campus, posted a video today on this topic (he is describing the helper column index method in his tutorial). I've always used the indexed helper column method and am curious if someone else has found another way of doing this.

Michael

 

[Yongle]

Another way (without VBA)

1. Copy DataSheet (right-cick on sheet tab \ select Move or copy \ check box for Create a copy \ OK)

2. Select DataSheet (2)

3. Sort in DataSheet (2)

4. When finished delete DataSheet (2)

 

[bearcub]

Thank you. It never occurred to me to make a copy of the original dataset and sort the duplicate. I don't know if this what Jon was asking but this would work, as a workaround.

 

[shg]

Ctrl+Z?

 

[bearcub]

That would work as well.