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

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
Oct 25, 2018
Reaction score
You could use an advanced filter to extract the unique values from the
column. There are instructions here:
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

Similar Threads