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

Make Home Buying Less Stressful! Why make home buying harder than it needs to be? Put your mind at ease—discover all the questions you need to ask to make the best buying decision.

Check out Buying a Home Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using Stored Views