Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create view using data autofilter
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. -- Arleigh Birchler |
#2
|
|||
|
|||
The simplest way I think is to record a macro that creates the view you
want. Bart Snel "Arleigh Birchler" schreef in bericht ... 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. -- Arleigh Birchler |
#3
|
|||
|
|||
You can create a Custom Views for the workbook:
Choose ViewCustom 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 ViewCustom 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 (ToolsCustomize) Arleigh Birchler wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I create a one variable data table? | Excel Discussion (Misc queries) | |||
Need to create a SUM for data in a row of cells containing IF fun. | Excel Discussion (Misc queries) | |||
How do I save autofilter data | Excel Discussion (Misc queries) | |||
How can I insert a vertical column break between data to create a. | Excel Worksheet Functions |