| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I pick row 3 to be the header row in Excel
I have a large spread sheet with three rows used as headers and on row three
I have all columns as auto filter. when I try to fiter on one of the columns the rows do not follow the column sort. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I pick row 3 to be the header row in Excel
Select the range of rows and columns you want to include before you sort or
filter. Don't let Excel guess which range you want. -- David Biddulph "vssimmons" wrote in message ... I have a large spread sheet with three rows used as headers and on row three I have all columns as auto filter. when I try to fiter on one of the columns the rows do not follow the column sort. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pick from table based on row and column header | Excel Worksheet Functions | |||
| Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
| Select max value in a row and pick the column header | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Linear Mode
