If the new print area is not adjacent to the existing print area, Excel would create a new print area and print it separately in a different page.Here are a few things you need to know while modifying print area in Excel: This would modify the print area and include the new cells. Note that the option to Add Print Area would be visible only when you have an existing print area in the Excel worksheet.Go to Page Layout –> Page Setup –> Print Area –> Add Print Area.If you want to add cells to the existing print area: When you set a print area in different worksheets, a named range Print_Area is created for each worksheet.The next time you open the workbook, the print area would still be there. When you save the workbook, Excel saves the print area as well.Hence, you can set different print areas in different worksheets. A print area specified using the above steps is specific to that worksheet only.To selected multiple areas, hold the Control Key and make the selection using the mouse. There can be multiple print areas in a worksheet, however, these are printed separately.

Here are some important things to know when you set the print area in Excel worksheets. Now when you print this worksheet, only the set print area would be printed. It also creates a named range for the selected area (the name Print_Area would be visible in the Name Box). This would set the selected cells as the print area.Go to Page Layout –> Page Setup –> Print Area –> Set Print Area.Select the range of cells that you want to set as the print area in that Excel worksheet.Here are the steps to set the print area in Excel: How to Set the Print Area in Excel Worksheets How to Set the Print Area in Excel Worksheets.For example, instead of printing the entire worksheet, if I only want to print the first 10 rows, I can set the first 10 rows as the print area. How to Set the Print Area in Excel WorksheetsĪ print area is a range of cells (contiguous or non-contiguous) that you designate to print whenever you print that worksheet.

How to set print area in excel