Identifying and Selecting the Print Area in a Sheet in Excel 2010

In this article, we will learn how to identify & select the print area in a sheet in excel.

Each sheet has only one print area. When you select the print area, Excel creates a name for it called Print Area.

To set print area:

  • Select the range of data cells that you want to set as your print area.
  • Click on Page Layout ribbon
  • In Page Setup group, click on Print Area
  • Click on Set Print Area

 
img1
 
Another way to set print area from Page Setup dialog box:

  • Click on Page Layout ribbon
  • From Page Setup group, click on Print Titles or click Dialog Box Launcher in the bottom-right corner of Page Setup group

 
img2
 

  • Click on Sheet tab
  • In the Print Area box, type the reference of the cells that you want to use as your print area, such as A1:F10.

 
img3
 
Click on Print Preview to check the set print area.

 

To set print area in Rows:

  • In Print titles
  • In the Rows to repeat at top box, type the reference as a title that you want to set. For example, $1:$1 for row 1.

 
img4
 

To set print area in Columns:

  • In Print titles
  • In the Columns to repeat at left box, type the reference as a title that you want to set as a title. For example, $A:$B for columns A and B.

 
img5
 

  • Click OK.

 
 

Users are saying about us...

  1. "Selecting Multiple Ranges
    Even with well-designed worksheets, you may want to select specific ranges that are not contiguous. Instead of printing each range on a separate page, you can print non-contiguous ranges in a cohesive printout.

    Select the first range to be printed

    Hold down the [Ctrl] key and select the second range to be printed

    Repeat step 2 for each additional range to be printed

    From the File menu, select Print...
    The Print dialog box appears.

    Under Print what, select Selection

    Click OK "

  2. "To print multiple print area :
    In Page Setup, select Sheet, click Print Area.
    Enter or select the first range to be printed and type coma (,) for the second range and so on for the third area.
    After selecting or typing all the areas, click OK."

Leave a Reply to Raphael Cancel reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube