On the Page Layout tab, in the Page Setup group, click the dialog launcher.Want to visually see all your settings? Here's a more transparent approach to defining a print area: More informative way to define print area in Excel On the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area.Ī faint gray line will appear denoting the print area.Select the part of the worksheet that you want to print.The quickest way to set a constant print range is this: To instruct Excel which section of your data should appear in a printed copy, proceed in one of the following ways. Without it, you may end up with messy, hard to read pages where some important rows and columns are cut off, especially if your worksheet is bigger than the paper you are using. If you change your mind at a later point, you can clear the print area or change it.ĭefining a print area gives you more control over what each printed page looks like and, ideally, you should always set a print area before sending a worksheet to the printer. Saving the workbook also saves the print area. You can select multiple print areas in a single worksheet, and each area will print on a separate page. When you press Ctrl + P or click the Print button on a sheet that has a defined print area, only that area will be printed. In case you don't want to print the entire spreadsheet, set a print area that includes only your selection. Then, hold down CONTROL and click the tabs of the other sheets that you want to select.A print area is a range of cells to be included in the final printout. Next to Print What, click the option that corresponds to what you want to print ( Selection, Active Sheets, or Entire Workbook) and then click Print.Ĭlick the tab for the first sheet. On the Printer pop-up menu, select the printer that you want. The Page Layout tab in the ribbon includes more options for page setup and printing, including page orientation, paper size and whether to print gridlines and headings. Select Show Details in the Print dialog box to print to a PDF file, or to set which pages to print, paper handling options, margins, and scaling. In the Print drop-down menu, select Selection, and then select Print. Or, for nonadjacent files, hold down COMMAND and select the name of each workbook that you want to print.Ĭlick a cell within the table to activate the table. Note: All of the workbook files that you want to print must be in the same folder.įor adjacent files, hold down SHIFT and select the name of each workbook that you want to print. Hold down CONTROL and click a sheet tab, and then click Select All Sheets on the shortcut menu. Then, hold down COMMAND and click the tabs of the other sheets that you want to select. Then, hold down SHIFT and click the tab for the last sheet that you want to select.Ĭlick the tab for the first sheet. Select the sheets that you want to print.Ĭlick the tab for the first sheet. In the Print drop-down menu, select the option that corresponds to what you want to print ( Selection, Active Sheets, or Entire Workbook) and then select Print. To change what is printed, select Show Details. The default is to print all active sheets. On the Printer menu, select the printer that you want.

To print a workbook, click any of its sheets. To print the entire sheet, click the sheet or the sheet tab.

To print a partial sheet, click the sheet, and then select the range of data that you want to print. Print a partial sheet, an entire sheet, or an entire workbook

Print selection