How do I pick row 3 to be the header row in Excel

V

vssimmons

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

David Biddulph

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.
 

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

Repeating a row other than the 1st row as the header row in a table from next page 1
Skipping the first row in a repeated header 0
Need Help with a VBA subroutine 0
Alternate Row Shading with Filter 1
Adding a big matrix in Word 2013 5
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
How do I freeze the swimlane headers? 0
Format column widths from one table to a separate table on same page 1

Top