Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude more than one row from data-Sort
Hi all! Is there a way to exclude more than one column header row from the Data-Sort function? I have a sheet which uses the first three rows for header information, but Data-Sort only allows me to exclude the first one. Your help would be much appreciated eZee -- eZee ------------------------------------------------------------------------ eZee's Profile: http://www.excelforum.com/member.php...o&userid=30837 View this thread: http://www.excelforum.com/showthread...hreadid=504985 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exclude more than one row from data-Sort
You can either 1) Only select the bottom most header row when selecting you range for sorting 2) Merge the three header cells into one cell and use the merged cell as your header row -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=504985 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Importing Data | Excel Worksheet Functions | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |