Is there a way to make a default option for Autofilter?

Closed
indydude71 Posts 2 Registration date Monday June 10, 2013 Status Member Last seen June 11, 2013 - Jun 10, 2013 at 07:40 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jun 13, 2013 at 10:52 AM
Hello,

I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just a single blank row or just the title columns if possible as a default for the table. That way the user can see the three options available and choose to expand the one they want, then if they want to contract the table they can select the filter/sort pull down menu and contract it back to just the blank row or title columns as a default filter. Is there any way to do that?

Thanks

3 replies

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 11, 2013 at 10:32 AM
Hi Indydude,

Not entirely sure but I think you are looking to "group" your data.

I can try to explain, but this site has pictures, so you will probably understand it in a blink of the eye:
https://www.wikihow.com/Group-and-Outline-Excel-Data

In Excel 2003 the option can be found in the Top menu > Data > Group and Outline.

Best regards,
Trowa
0
indydude71 Posts 2 Registration date Monday June 10, 2013 Status Member Last seen June 11, 2013
Jun 11, 2013 at 10:45 PM
My boss doesn't like the grouping feature and wants me to keep the look of just the drop down that the autofilter has but wants it to just display the column title row of the table as the default selection and then be able to filter/unfilter the data from the drop down. I tried to paste a screenshot of what I have now but the site won't let me do it.
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 13, 2013 at 10:52 AM
It sounds to me like you just described the function of autofilter.

I would really like to see what you mean. These sites will allow you to upload your workbook so you can post back the download link:
www.speedyshare.com
ge.tt
For screenshot you can refer to:
www.imageshack.com

Best regards,
Trowa
0