Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting automatically by columns
I have a sheet listing a lot of music albums. About 450 album titles
with 15 columns of data about each album. Below that "table" are some summary statistics such as average album length and number of tracks. What I'd like to be able to do is choose any of the 15 columns and sort thereon (without disturbing the summary statistics below). I realize I can select the "table" cells and then go through the Data | Sort... dialog, but I am hoping there's a way to speed up the process, maybe a one-click deal. Is there a way? Thanks for any ideas you have. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting automatically by columns
Insert a blank row between the table and the summary data.
-- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "HumingBean" wrote in message I have a sheet listing a lot of music albums. About 450 album titles with 15 columns of data about each album. Below that "table" are some summary statistics such as average album length and number of tracks. What I'd like to be able to do is choose any of the 15 columns and sort thereon (without disturbing the summary statistics below). I realize I can select the "table" cells and then go through the Data | Sort... dialog, but I am hoping there's a way to speed up the process, maybe a one-click deal. Is there a way? Thanks for any ideas you have. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting automatically by columns
How does that help me sort with one or two clicks on the table data?
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting automatically by columns
The summary area will not be included in the selected data.
-- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "HumingBean" wrote in message How does that help me sort with one or two clicks on the table data? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting automatically by columns
On Nov 30, 7:55 pm, "Jim Cone" wrote: The summary area will not be included in the selected data. Yes, but what does that have to do with speeding up the sorting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting two columns at the same time | Excel Worksheet Functions | |||
Sorting multiple columns | New Users to Excel | |||
Set options for sorting columns in a worksheet | Excel Discussion (Misc queries) | |||
Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
Sorting two columns | Excel Worksheet Functions |