Watch Video – How to Set the Print Area in Excel Show
If you need to print your work in Excel, this tip would save you some papers. Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed. This technique could be useful if you want to print only a part of a report or there is a section of the report that you need to print often.
Print Area in Excel WorksheetsA print area is a range of cells (contiguous or non-contiguous) that you designate to print whenever you print that worksheet. 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. In this tutorial, you’ll learn:
How to Set the Print Area in Excel WorksheetsHere are the steps to set the print area in Excel:
Now when you print this worksheet, only the set print area would be printed. Here are some important things to know when you set the print area in Excel worksheets.
How to Modify the Print Area in ExcelIf you want to add cells to the existing print area:
This would modify the print area and include the new cells. Here are a few things you need to know while modifying print area in Excel:
How to Clear the Print Area in ExcelHere are the steps to clear the print area:
This will clear all the print areas (in case you have set more than one range of cells). In case, you only want to remove some cells and not clear the entire print area, edit the name range from the name manager. You May Also Like the Following Excel Tutorials:
How do I print selected area on one page?Set one or more print areas. On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print. ... . On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.. How do I print only a selected area?Change a selected print area
Select File > Print > Print. To print only the selected area, in Print Options, select Current Selection. If the print preview shows what you want printed, select Print.
How do I print different columns on one page in Excel?Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page. To print your worksheet on a single page, choose 1 page in the Height box.
How do I print multiple selections on one page in Excel?Multiple Print Areas on a Single Printed Page in Excel. Open the worksheet that you want to print.. Click the Page Layout tab.. In the Page Setup group, click Print Area.. Click Set Print Area.. Select the range of cells that you want to print. ... . Click OK.. |