ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do i move the filters from the columns on line one to the col. (https://www.excelbanter.com/excel-worksheet-functions/7050-how-do-i-move-filters-columns-line-one-col.html)

dstevo2

How do i move the filters from the columns on line one to the col.
 
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.

CarlosAntenna

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

Carlos

"dstevo2" wrote in message
...
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.





All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com