Excel Print Visible Only Manual Page Breaks

To get back to the original size, click the Zoom to Page button in the lower-right corner.

Just click the Print button, right In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page.

This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper.

Our tips will work for all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 and lower.

And then, we will have a closer look at the most important and useful features.

To select non-adjacent cells or ranges, hold the Ctrl key while selecting.

This option appears only when the table or its part is selected.

To select adjacent sheets, click the first sheet tab, hold the Shift key and click the last sheet tab.

If you selected just one range per sheet, the number of pages should match the number of selected sheets.

If two or more ranges are selected, each will be printed on a separate page, so you multiply the number of sheets by the number of ranges.

To print an Excel sheet on one page, choose one of the following Scaling options that reside at the end of the Settings section in the Print Preview window.

To check how much scaling will actually be used, click Custom Scaling Options.

This will open the Page Setup dialog box, where you look at the number in the Adjust to box.

The default Portrait orientation works well for worksheets that have more rows than columns.

If your sheet has more columns than rows, change the page orientation to Landscape.

To print an Excel spreadsheet on a predefined number of pages, on the Page tab of the Page Setup dialog, under Scaling, enter the number of pages in both Fit to boxes (wide and tall).

Excel Print Visible Only Manual Page Breaks

Please note that using this option will ignore any manual page breaks.

In short, this option saves output to a file instead of sending it to a printer.

The idea is that you configure the print settings (margins, orientation, page breaks, etc.) only once and save the output to a.pdf document.

Next time you need a hard copy, simply open that.pdf file and hit Print.

It not only shows exactly how your worksheets will look on paper, but also allows making certain changes directly in the preview window.

The arrows only appear when a selected sheet or range contains more than one printed page of data.

You can also adjust the column width by dragging the handles at the top or bottom of the print preview window.

Excel For Mac Print Visible Only