Create view using data autofilter

[Guest]

I use Excel quite a lot, and would like to expand my ability. I use the
AutoFilter feature to look at particular data. Usually it involves filtering
a few different columns. I would like to set-up some "Views" that define the
conditions and values for several columns. I could then click on one thing
and get the pre-defined sets of data.

 

[Bart Snel]

The simplest way I think is to record a macro that creates the view you
want.

Bart Snel

 

[Debra Dalgleish]

You can create a Custom Views for the workbook:

Choose View>Custom Views
Click Add
Type a name for the Custom View
Check the box for 'Hidden rows, columns and filter settings'
Click OK

To show a Custom View, choose View>Custom Views, select a view, click Show

You can also create a Custom View with all Filters removed, and show it
as required.

If you use Custom View frequently, you can add the Custom Views dropdown
to one of your toolbars (Tools>Customize)