sorting data in columns
 

How can I sort multiple columns simultaneously? i.e. I have sixteen columns
of numerical data that I want to be able to apply the same Sort to each
column individually but I do not want to have to highlight each column
separately as this will take considerably longer.

Save your workbook first!

Try sorting one column, then selecting the next and hit the F4 key.
It shouldn't take too long if it works ok.



Spiderman wrote:

How can I sort multiple columns simultaneously? i.e. I have sixteen columns
of numerical data that I want to be able to apply the same Sort to each
column individually but I do not want to have to highlight each column
separately as this will take considerably longer.

--

Dave Peterson

Ok, that worked, also I figured if you just include the header row you can
sort all columns simultaneously

"Dave Peterson" wrote:

Save your workbook first!

Try sorting one column, then selecting the next and hit the F4 key.
It shouldn't take too long if it works ok.



Spiderman wrote:

How can I sort multiple columns simultaneously? i.e. I have sixteen columns
of numerical data that I want to be able to apply the same Sort to each
column individually but I do not want to have to highlight each column
separately as this will take considerably longer.

--

Dave Peterson