Reverting back to Original Column Sort order

bearcub

Well-known Member
Joined
May 18, 2005
Messages
638
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
 

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,977
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
638
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,833
Office Version
  1. 2010
Platform
  1. Windows

bearcub

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,601
Messages
5,838,311
Members
430,537
Latest member
Antonio11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top