Nicely formatted Excel filter

[kidrobot]

Does anyone have any example Excel filters? I'm making something for my managers and I want this to almost look like an Access form that is nicely formatted in Excel. Please send examples!!

 

[kidrobot]

Also, is there a way to take the "ALL" setting off of the auto filter?

Also, is there a way to reset the auto filter? Like a button, to be user friendlY?

 

[shades]

Howdy. When you write "reset auto filter", that normally means "show all". But you don't want that. I'm not sure what you mean by "reset auto filter"?

Have you considered using Custom Views and then controlling access that way?
________
ROLL A JOINT

 

[kidrobot]

Shades, I'll take a look into it and let you know. Thanks, for always helping me with my Excel issues.

 

[kidrobot]

Howdy. When you write "reset auto filter", that normally means "show all". But you don't want that. I'm not sure what you mean by "reset auto filter"?

Have you considered using Custom Views and then controlling access that way?

What I did was made a row that is just a blank line. These boxes are supposed to cascade respectivley with one another. So I guess what I meant by the 'reset' button was for some way to make the first columns filter return to "blank" and the rest of the filters return to "all". Let me know if that is clear.

and when I said I wanted to remove the "All", I was thinking about removing the "All" only for that first column if at all possible.

 

[kidrobot]

any recommendations?

 

[shades]

I have been overwhelmed by work, so haven't looked at it yet.
________
VAPORIZER FORUM

 

[kidrobot]

I have been overwhelmed by work, so haven't looked at it yet.

No problem, just let me know what you think when you get a chance. Or anyone else can take a look.