Chapter 5. View

Excel allows you to select how a workbook is viewed or printed. This type of setting is called a view. Excel provides some basic view modes that are available on the View menu for all workbooks that you open. For example, the Normal option displays the entire contents of the workbook, with the exception of any cells that may be hidden. If you select the Page Break Preview option you are able to see exactly where the page breaks will occur in your worksheet if you print it, and make any desired modifications.

Excel also allows you to create custom view modes for each workbook that you open. These view modes are custom created for each workbook using the View Custom Views option. For example, you might want to set a custom view that hides the individual sales figures for each employee and only displays the totals.

With each custom view you create, Excel stores the following information:

  • Active cell

  • Active worksheet

  • Widths of all columns within each worksheet in the workbook

  • Display options that are specified when you select Tools Options

  • Size and position of the Excel window

  • Selected cells within the active worksheet

  • Hidden rows, hidden columns, and filter settings for a workbook, if you select the “Hidden rows, columns and filter settings” checkbox on the Add View dialog that displays when you create a new custom view (see View Custom Views)

  • Print settings, if you select the Print settings checkbox on the Add View dialog that displays when you create a new custom view ...

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.