#Excel print selection to fit page plus

The selected cells will change color as you click the next group of cells.Ĭlick the “Page Layout” tab on the command ribbon.Ĭlick “Print Area” in the “Page Setup” group to open a short list of two options: “Set Print Area” and “Clear Print Area.”Ĭlick “Set Print Area.” Your selected area will show an outline of broken lines.Ĭlick the “File” tab on the command ribbon to show a list of options.Ĭlick “Print” to display a preview of the selected cells in the right pane. Alternate Strategy: You can use the Page Layout dialog to indicate that the report should fit to one page wide by pages tall.

To select multiple print areas, hold down the “Ctrl” key on your keyboard and click each area on the worksheet. Have tried everything from printing selection only, macro to set print margins, manually setting print margins, changing fonts, and size, different printers, resizing columns to larger than needed.

In the Print Multiple Selection Wizard, click button to select and add the range that you want to print into the Ranges to print list box one by one, (you can select the. Excel will not Fit All Columns on One Page - only uses 2/3 of the page.

#Excel print selection to fit page plus

Click Kutools Plus > Printing > Print Multiple Selection Wizard, see screenshot: 2. The selected cells will display a dark outline. After installing Kutools for Excel, please do with following steps: 1. Click and drag the cursor to highlight those cells for the selected print area.