The Custom Views feature allows you to set up and save different views to quickly switch among them.

The following settings are included in custom views: the zoom level, the current cell selection, column widths and row heights, display settings on the Advanced tab of the Excel Options dialog box, the current size and position of the document window, the window pane arrangement (including frozen rows and columns ), and optionally print settings (including page setup) and hidden columns and rows.

To set the current view as the normal view, click the View tab.

Either check or uncheck the Print settings and Hidden rows, columns and filter settings boxes depending on what you want to include in the view.

Set up the view the way you want it and then click Custom Views in the Workbook Views section on the View tab.

You can also double-click the name of the view you want to show.

When you choose a custom view to show for a worksheet that is not currently active, Excel activates that worksheet and applies the view.

So, you must create custom views for each worksheet in each workbook separately and be sure to save your workbook with your custom views.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

Setting Up Mac Excel For Histogram