This only works for non-contiguous ranges. To select multiple ranges, please remember to hold the Ctrl key. On the Sheet tab, put the cursor in the Print area field, and select one or more ranges in your worksheet.This will open the Page Setup dialog box. 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. This feature is known as Print Area.Ī print area is a range of cells to be included in the final printout. But what if you don't really need all the content of a huge worksheet on paper? Luckily, Excel provides the ability define the parts for printing. When you hit the Print button in Excel, the entire spreadsheet is printed by default, which often takes multiple pages. In this tutorial, you will learn how to select print area in Excel manually and how to set print ranges for multiple sheets by using macros.

Excel for mac tutorial print