Reverting back to Original Column Sort order

bearcub

Well-known Member
Joined
May 18, 2005
Messages
624
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,787
Office Version
  1. 365
Platform
  1. Windows
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)
 
Last edited:

bearcub

Well-known Member
Joined
May 18, 2005
Messages
624
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
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

MrExcel MVP
Joined
May 7, 2008
Messages
21,770
Office Version
  1. 2010
Platform
  1. Windows

bearcub

Well-known Member
Joined
May 18, 2005
Messages
624
Office Version
  1. 365
  2. 2013
  3. 2010
  4. 2007
Platform
  1. Windows
That would work as well.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,492
Messages
5,529,173
Members
409,854
Latest member
rickcoba
Top