ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Column Sorting (https://www.excelbanter.com/new-users-excel/256915-column-sorting.html)

trvlnmny

Column Sorting
 
I am using W XP & Excel 2003. I would like to know if there is a way
to sort on more than 3 columns? If so how is it done?
Thanks for the help.

Dave Peterson

Column Sorting
 
You can use data|sort as many times as you need. Sort by the 3 least important,
then the next 3, then the next 3, ..., until you get to the 3 most important.

Maybe you could even record a macro when you do it once (er, as many as you need
to) manually. Then just re-run that macro when you need to do it again.

trvlnmny wrote:

I am using W XP & Excel 2003. I would like to know if there is a way
to sort on more than 3 columns? If so how is it done?
Thanks for the help.


--

Dave Peterson


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com