ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filtering Handles (https://www.excelbanter.com/excel-discussion-misc-queries/101455-filtering-handles.html)

Michael Link

Filtering Handles
 
Is it possible to set up a filtered list so that filter handles/drop-downs
are visible but aren't adjacent to the list? The way my list is set up, there
are a number of rows underneath the head row that contain important
information but which cannot move or be included in a sort. I can use the
Advanced Filter function to specify a range, but many people will use this
and most of them probably don't know how to do that. Ideally I would have
handles/drop-downs permanently visible (like what you get in a List Box or
with AutoFilter), but, again, not adjacent to the list itself. Is this
possible?


All times are GMT +1. The time now is 10:09 AM.

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