Excel - Sort

[rekoop]

Hello,

I have a four level sort that I use quite often. It is
possible to "save" my sort parameters/order so I do not
have to set it up each time?

All suggestions are appreciated.

 

[Paulw2k]

Use a macro to sort. You can record most of the recording with a practice
run, then twig it appropriately

 

[DDM]

Rekoop, one way to approach this is to use a "helper" column. Say you
regularly sort on Columns D-A. In a helper column right next to the data,
enter a formula that combines the values from these columns: =D2&C2&B2&A2
(assuming you have column labels in Row 1). Copy the formula down for as
many rows as you have data. Hide the column, then use it to sort on.