News and Notes

Multiple Print Settings

Keeping Multiple Print settings in the same file.
This is one of the more frequent requests I get. Customers want me to program multiple print settings into the same Excel file. Unfortunately (for me), this is a feature that is built into Excel!
What are Print Settings? Print Settings are the settings in the Page Setup Dialog Box; these include Paper Size, Orientation, Margins, Headers/Footers, the Print Area and Titles.
Depending on who is receiving your spreadsheet, you may wish to include different print areas, change your headers/footers and make other changes. Many excel users address this problem by having multiple versions of the same file. Unfortunately, this always leads to problems determining which file is the most recent and most accurate version of the file.

The reason people don’t find this handy Printing feature is that it is stored under the View menu. Custom Views Dialog

The Custom Views menu choice is under the View menu.

Adding a custom view is a pretty straightforward process.

Give the View a name and make sure the Print Settings option is checked. Custom Views Dialog - Add View
As a bonus, you can include any hidden row/column settings, and filter settings as part of the view.

I recommend when using custom views, that the first view you create is a plain “vanilla” view, without any print settings, hidden rows/columns or filters. This means that you can easily return to a plain view from any other view.

Custom Views Dialog

Selecting your custom view is as simple as selecting it and using the Show button.

You can also add a Custom View toolbar button that will display all views in the file.

News and Notes

Multiple Print Settings

Other News and Notes Articles