Applying print settings on demand
By default, Custom Views captures the print settings currently in place for each worksheet included in the view, unless you clear the Print Settings checkbox when creating a view. Let’s create an audit view of a worksheet that will illustrate some additional settings that you can manage by way of the Custom Views feature:
- Open the example workbook for this chapter and activate the Loan Calculator worksheet.
- Maximize the worksheet window if necessary so that you can see how Custom Views can resize windows:
- Excel for Windows: Click the Maximize button, which looks like a square in the top right-hand corner of the title bar.
Tip
If you see two overlapping squares in the top right-hand corner of the title bar – which represent the Restore Down button – then your window is already maximized.
- Excel for macOS: Click the green Enter Full Screen button in the title bar of the window.
- Choose View...