How do I filter data without including the header row?

D

Donald

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.
 
W

www.exciter.gr: Custom Excel Applications!

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I print rows that go outside of the page without shrinking the text? 0
Need Help with a VBA subroutine 0
Table Header Cells keep shifting 8
Macro Pause to Select range then Subtotal 0
Autofilter includes extra row 4
Sort doesn't always work 1
Checkbox issue - Checkbox overlapping when filter is applied 1
data spans multiple rows within each cell is collapsed when FILTER is used 0

Top