bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Tools > Deleting a View

Deleting a View

Summary: After a time, you may not need a worksheet view that you previously saved. This tip explains how to get rid of those unwanted views in quick order. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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:

  1. Choose the Custom Views option from the View menu. Excel displays the Custom Views dialog box. (Click here to see a related figure.)
  2. From the list at the left side of the dialog box, select the view you want to delete.
  3. Click on the Delete button. Excel asks if you want to delete the view.
  4. Click on OK. The view is removed from the list of those available.
  5. Repeat steps 2 through 4 for each additional view you want to delete.
  6. Click on Close to get rid of the Custom Views dialog box.

Tip #2867 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


More Power! Expand your skills and make Excel really sing! It's all possible with macros. The best resource anywhere for macros is ExcelTips: The Macros. Check it out today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)