Deleting a View

Summary: When you no longer need a view, you can get rid of it by deleting it. Deleting unnecessary views is a good idea because it decreases the complexity of your worksheets. This tip explains how to get rid of unwanted views. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

It is inevitable—whenever you add something, you will later want to delete it. When you have finished with a project or you simply no longer have need for a particular view, you will want to get rid of it. To do this, follow these steps:4

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.
From the list of views in the dialog box, select the view you want to delete.
Click on the Delete button. Excel asks if you want to delete the view.
Click on OK. The view is removed from the list of those available.
Repeat steps 2 through 4 for each additional view you want to delete.
Click on Close to get rid of the Custom Views dialog box.

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

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Deleting a View