Working with Special Features

Close Window 

Working with Custom Views

A Custom View is a set of worksheet settings that you save. A Custom View can include print settings, hidden column and row settings, and filter settings. With a Custom View, you can set up your worksheet the way you want to view or print it, then save the setup so you can bring it back later. This can come in handy. Consider:

To create a Custom View, first set up your worksheet the way you want it, then follow these steps:

  1. Select Custom Views from the View menu.

  2. In the Custom Views dialog box, click the Add button.

  3. In the Add View dialog box, enter a name for your view.

  4. Select the options you want.

  5. Click OK.

Now here’s how to apply a Custom View:

  1. Select Custom Views from the View menu.

  2. In the Custom Views dialog box, select the view from the Views list.

  3. Click Show.

Excel switches to the worksheet with the Custom View, applies the view settings, and puts the pointer in whatever cell was active when you saved the view.

(Posted 09/16/2001)

Tip-within-a-tip:

"What we really love about Custom Views is the way Excel remembers all our print settings – not just the Print Area, but every selection we made in the Page Setup dialog box."