ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   filter: how to print filter list options in dropdown box (https://www.excelbanter.com/excel-discussion-misc-queries/162344-filter-how-print-filter-list-options-dropdown-box.html)

Help Please

filter: how to print filter list options in dropdown box
 
I want to print the list of options in my filter list, but do not see how to
print except for a print screen option. How can I print only the filter
options?

Gord Dibben

filter: how to print filter list options in dropdown box
 
Is this referring to DataFilterAutofilter?

The list of options is what is in the column you select to filter.

Print that column only.


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 13:28:00 -0700, help please <help
wrote:

I want to print the list of options in my filter list, but do not see how to
print except for a print screen option. How can I print only the filter
options?



Debra Dalgleish

filter: how to print filter list options in dropdown box
 
You could use an advanced filter to extract the unique values from the
column. There are instructions he

http://www.contextures.com/xladvfilter01.html

help please wrote:
I want to print the list of options in my filter list, but do not see how to
print except for a print screen option. How can I print only the filter
options?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:24 AM.

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