MS-Excel / General Formatting

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:

  1. 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.
  2. Click the Add button. The Add View dialog box appears.
  3. 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.
[Previous] [Contents] [Next]

In this tutorial:

  1. Refining Excel Worksheet
  2. Editing Worksheet Data
  3. Moving Around in a Worksheet
  4. Better Look at the Worksheet
  5. Freezing and splitting columns and rows
  6. Your own customized views
  7. Hiding columns and rows
  8. Comments for Documenting Your Worksheet
  9. Selecting Cells in a Worksheet
  10. Deleting, Copying, and Moving Data
  11. Handling the Worksheets in a Workbook
  12. Tampering with Worksheets
  13. Hiding a worksheet
  14. Protecting a worksheet