Microsoft Office Tutorials and References
In Depth Information
Using custom views
Note
The wheel on a mouse ordinarily scrolls the worksheet. You can also use the wheel to
zoom. Simply hold down the Ctrl key and rotate the wheel. If you prefer, you can make
zooming the default behavior of the wheel. To do so, click the File tab, click Options,
select the Advanced category, and select the Zoom On Roll With IntelliMouse check
box in the Editing Options area.
Using custom views
Suppose you want your worksheet to have particular display and print settings for one
purpose, such as editing, but different display and print settings for another purpose, such as
an on-screen presentation. By clicking the Custom Views button on the View tab, you can
assign names to specific view settings, which include column widths, row heights, display
options, window size, position on the screen, pane settings, the cells that are selected at the
time the view is created, and, optionally, print and filter settings. You can then select your
saved view settings whenever you need them rather than manually configuring the settings
each time.
Note
Before you modify your view settings for a particular purpose, you should save the
current view as a custom view named Normal. This provides you with an easy way to
return to the regular, unmodified view. Otherwise, you would have to retrace all your
steps to return all the view settings to normal.
In the Custom Views dialog box, the Views list is empty until you click Add to save a custom
view. All your custom views are saved with the workbook. Figure 6-21 shows the Custom
Views dialog box with two views added, as well as the Add View dialog box you use to add
them.
Figure 6-21 Click Add to name the current view and print settings in the Custom Views
dialog box.
Search JabSto ::




Custom Search