Your own customized views
After you go to the trouble of freezing the screen or zooming in to a position you're comfortable with, you may as well save your view of the screen as a customized view. That way, you can call upon the customized view whenever you need it. View settings, the window size, the position of the grid on-screen, and cells that are selected can all be saved in a customized view.
Follow these steps to create a customized view:
- On the View tab, click the Custom Views button.
You see the Custom Views dialog box. It lists views you've already created, if you have created any. - Click the Add button. The Add View dialog box appears.
- Enter a name for the view and click OK.
To switch to a customized view, click the Custom Views button, select a view in the Custom Views dialog box, and click the Show button.
In this tutorial:
- Refining Excel Worksheet
- Editing Worksheet Data
- Moving Around in a Worksheet
- Better Look at the Worksheet
- Freezing and splitting columns and rows
- Your own customized views
- Hiding columns and rows
- Comments for Documenting Your Worksheet
- Selecting Cells in a Worksheet
- Deleting, Copying, and Moving Data
- Handling the Worksheets in a Workbook
- Tampering with Worksheets
- Hiding a worksheet
- Protecting a worksheet