Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |