The Auto Filter button lost the column specified option.

G

Guest

I created a form and used the Auto Filter buttons to show the column catagory
when chosen. The column catagory is now gone from the options defeating the
filter purpose. I know all the columns button need to be on "all" to have one
show its title to filter it . When opening the Auto Filter:
Sort
Ascending
Sort
Descending

(All)
(Top
10...)

(Custom...)
options come up but not my colunms catergory.
HELP.
D
 
G

Gord Dibben

D

The Data>Filter>Autofilter dialog box does not show Sort Ascending or
Descending.

The Data>Sort dialog does, however.

Are you confusing the two or am I confused by your description of your
problem.

Gord Dibben Excel MVP
 

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

Auto filter sort ascending not working while sheet protected 6
Expand Selection in Auto filter 7
Auto Filter Comma Dilemiation 2
Column hidden and Auto filter 2
Select specific column for auto filter 4
Drop Down Sort Button. 2
Filter by Top 10 doesn't work 1
Hidden Rows with Auto-Filter 2

Top