Using Stored Views

Summary: After creating different views of your worksheet data, you can display those views by simply selecting which one you want to see. This tip explains how this works. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Once you have defined the views for a worksheet, you can use them to look at your information in different ways quickly. To select different views, follow these steps:

Display the Custom Views dialog box. (Click here to see a related figure.) In Excel 2007 display the View tab and click Custom Views in the Workbook Views group. In earlier versions of Excel select the Custom Views option from the View menu.
Select a view from those listed in the dialog box.
Click on the Show button. Your display settings are changed to reflect what was previously saved in the view.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2866) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.

Check out PivotTables for the Faint of Heart today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using Stored Views