If you prefer, you can also set the print area in advance so you'll be able to visualize which cells will be printed as you work in Excel. Simply select the cells you want to print, click the Page Layout tab, select the Print Area command, then choose Set Print Area.

Fitting and scaling content
On occasion, you may need to make small adjustments from the Print pane to fit your workbook content neatly onto a printed page. The Print pane includes several tools to help fit and scale your content, such as scaling and page margins.To fit content before printing:
If some of your content is being cut off by the printer, you can use scaling to fit your workbook to the page automatically.- Navigate to the Print pane. In our example, we can see in the Preview pane that our content will be cut off when printed.

- Select the desired option from the Scaling drop-down menu. In our example, we'll select Fit Sheet on One Page.

