save one page of an excel worksheet and share for mac

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

You can set up a different view for each worksheet and save each view.

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.

As an example, were going to create a view with a 150 zoom and the Formula Bar and Headings hidden, so we can read our spreadsheet easily and have a bit more room on the worksheet.

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

They are also worksheet-specific, meaning that a custom view only applies to the worksheet that was active when you created the custom view.

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.

Save One Page Of An Excel Worksheet And Share For Mac