filter: how to print filter list options in dropdown box


G

Guest

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?
 
Ad

Advertisements

G

Gord Dibben

Is this referring to Data>Filter>Autofilter?

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
 
Ad

Advertisements

Joined
Oct 25, 2018
Messages
1
Reaction score
0
You could use an advanced filter to extract the unique values from the
column. There are instructions here:

http://www.contextures.com/xladvfilter01.html
Not sure if it's the same but I actually want to screen dump the list of options to use in a tutorial. How do I take a screen dump after clicking the filter button? As soon as I use the Alt button the options disappear. I thought that I could use Cntl but that doesn't work,
 

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

Top