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:
- Go to
and select the worksheet area for your view.
- Go to
View | Custom Views.
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:
to Tools | Customize.
the Toolbar tab and click New.
a name for your toolbar (for example, Presentation).
the Commands tab.
View under Categories.
Custom Views under Commands and drag it to your custom toolbar.
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.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays