| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I filter data without including the header row?
When filtering my data in spread sheet it continues to include my header rows
as apart of the filtering process, I've tried freezing the frame to include columns. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I filter data without including the header row?
Try selecting only the range and not the header cell before applying a
filter. For example, select A2:A100 and then apply filter. http://www.exciter.gr Custom Excel Applications and Functions! On Nov 2, 1:18 pm, Donald wrote: When filtering my data in spread sheet it continues to include my header rows as apart of the filtering process, I've tried freezing the frame to include columns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a worksheet without including the column header row | Excel Discussion (Misc queries) | |||
| Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
| Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
| Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
| How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
Linear Mode
