Use custom views in Excel to enhance your presentations

With Microsoft Excel's custom views, you can readily access whatever worksheet areas you need, which will help your presentations to flow. Here's how to get started.

You want to illustrate your talk by pointing out selected areas of your worksheets. Rather than interrupting the flow of your presentation by having to scroll to and position each area as needed, you could create custom views in Microsoft Excel, which you can readily access by clicking on a list in your toolbar.

First, you will need to create custom views. To do so, follow these steps:

  1. Go to and select the worksheet area for your view.
  2. Go to View | Custom Views.
  3. Click the Add button, and then enter a name for the view and click OK.

Repeat these steps for each custom view you want to present. To build the custom toolbar for your presentation, follow these steps:

  1. Go to Tools | Customize.
  2. Click the Toolbar tab and click New.
  3. Enter a name for your toolbar (for example, Presentation).
  4. Click the Commands tab.
  5. Click View under Categories.
  6. Click Custom Views under Commands and drag it to your custom toolbar.
  7. Click Close.

To quickly go to a view during your presentation, click the drop-down arrow on the Custom View button and select the view from the list.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox