Print Tag of Autofilter?

[KK]

Hi everyone,

does anyone knows how to print out drop-down tag from
AutoFilter in a spreadsheet?

cheers,

KK

 

[BrianB]

Make a Pivot Table of your data.
Set it to not show totals.
Hide the other columns

 

[Dave Peterson]

Is a dropdown tag the list of unique values that shows up when you click on that
dropdown arrow?

If yes, then maybe you can use Data|filter|advanced filter to extract those
unique values.

Debra Dalgleish has some nice instructions (with pictures!) at:
http://www.contextures.com/xladvfilter01.html#FilterUR

Or is the Tag the dropdown arrow itself?

Maybe you could put a triangle from the drawing toolbar in that corner to give
it that appearance.

Or
insert a new sheet
back to your autofilter range
select your range (just a page full)
Edit|Copy
back to the new sheet
select A1
Shift-Edit|Paste Picture link

(smaller pictures came out better in my limited testing.)