How do i move the filters from the columns on line one to the col.

D

dstevo2

I have been having trouble with the filters on Excel.

When i click Data, Filter, Auto Filter

The Filter arrows go in the top Row (1) in the bottom right hand corner of
the merged cells in that row. What i want to happen is move these arrows to
row three and the columns i want them in.
 
C

CarlosAntenna

Select row 3 thru ? of the column you want to filter before applying the
filter.

Carlos
 

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

Format column widths from one table to a separate table on same page 1
How do I filter data by more than one column in excel 0
Merged cells disturb autofilter indicator 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
auto filter on columns 2
Auto Filter - It's broken! Help! (Office '03) 2
Merging from an Excel file with graphics 1
Using the IF and Sheets 0

Top