| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort with multiple header rows
I have three rows at the top of my Excel spreadsheet. One row is the column
names; the other two rows contain data used in formulae elsewhere in the spreadsheet. Is there any way to do it without first selecting the data? I've found this method is very prone to error. How do I sort the data without sorting in the three header rows? Designating "header row" in the sort dialogue only identifies one row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) | |||
| How to sort by grouped rows | Excel Discussion (Misc queries) | |||
| How to exclude header row from sort button sorts? | Excel Discussion (Misc queries) | |||
| Sorting and Header Row's | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
