| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I sort with header not on row 1
Hi, I would like to sort 'by header' when the headers are on row 5. I know that I can highlight all the rows from 5 to bottom of the sheet manually then sort by header row but with a large sheet this is time consuming. I would like to select the entire sheet and then sort by header(on row 5) Is this possible? -- tryer ------------------------------------------------------------------------ tryer's Profile: http://www.excelforum.com/member.php...o&userid=16546 View this thread: http://www.excelforum.com/showthread...hreadid=528692 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| SORT Header Row(s) | Excel Discussion (Misc queries) | |||
| Excel needs to let the user set the sort default to "NO HEADER ROW | Excel Worksheet Functions | |||
| How do I make the sort default to 'No header rows' | Excel Discussion (Misc queries) | |||
| Changed Titled bar and now sort doesn't default to "Header Row" | Excel Discussion (Misc queries) | |||
Threaded Mode
