![excel print selection to fit page excel print selection to fit page](https://lh6.ggpht.com/-A0tG8cFL9xc/U12oZPUIGNI/AAAAAAAATp8/ddO71wbWY_s/NPOIConvertSpreadsheetToHTML-Spreadhseet_thumb%25255B3%25255D.png)
Go to the 'File' menu and select 'Print'. Click and hold the first cell in the range and drag the cursor until youve highlighted all the cells that you want to print. Highlight the cells that you want to print. Select Print Active Sheets from the print range drop-down menu. You may need to add more cells to your print area after you set it up. Double-click the worksheet or go to 'File > Open' in Excel. To print multiple worksheets, click the first worksheet, hold down the Ctrl key, then click the other worksheets you want to select.
#Excel print selection to fit page code
Click Insert > Module, and paste the following code in the Module Window.
![excel print selection to fit page excel print selection to fit page](https://cdn.extendoffice.com/images/stories/doc-excel/print-each-rows/doc-insert-page-break-every-row.png)
On the Page Layout tab > Scale to fit group you will see a number of options. First, open the worksheet the you want to print. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. By scaling a worksheet in page setup before you print, you can control its width and number of pages, there are two ways of doing this: 1. When you finish, click “Normal” or “Page Layout” to return to your sheet, depending on which view you were using. Press Ctrl key to select the ranges that you want to print. Open the View tab and select “Page Break Preview.” You’ll then see each print area you’ve set for that sheet. Once you set up your print area, you may want to confirm you’ve selected the right cells. This allows you to quickly print that same spot without resetting the print area. When it’s time to print, each print area will display on its own page.Īfter you set a print area in your Excel sheet, it will save automatically when you save your workbook.
![excel print selection to fit page excel print selection to fit page](https://www.exceldemy.com/wp-content/uploads/2022/07/Delete-Blank-Pages-in-Print-Preview-in-Excel-5-2048x1866.png)
Next, head to the Page Layout tab and pick “Set Print Area” in the Print Area drop-down box. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13.