Setting the Print Area

In this topic, you will learn how to set the Print Area in Excel 2010.


  1. On the worksheet, select the cells that you want to define as the print area.

    Step 1
  2. You can create multiple print areas by holding down the [Ctrl] key and clicking the areas you want to print.

    Step 2
  3. Click the Page Layout tab.

    Step 3
  4. Click Print Area.

    Step 4
  5. Click Set Print Area

    Step 5
  6. Click the File Tab.

    Step 6
  7. Click Print.

    Step 7
  8. Click Show Print Preview.

    Step 8
  9. The print area that you set is saved when you save the workbook.


    Now we will add cells to an existing print area.

    Step 9
  10. Click the Home tab.


    Step 10
  11. On the worksheet, select the cells that you want to add to the existing print area.

    Step 11
  12. Click the Page Layout tab.

    Step 12
  13. Click Print Area 

    Step 13
  14. Click Add to Print Area

    Step 14
  15. Click the File Tab.

    Step 15
  16. Click Print.

    Step 16
  17. Click how Print Preview.

    Step 17
  18. If the cells that you want to add are not adjacent to the existing print area, an additional print area is created. 


    Click the Next Page button.

    Step 18
  19. Each print area in a worksheet is printed as a separate page.


    Now we will clear the print area.

    Step 19
  20. Click the Home tab.

    Step 20
  21. Click the Page Layout tab.

    Step 21
  22. Click Print Area

    Step 22
  23. Click Clear Print Area

    Step 23
  24. Click the File Tab

    Step 24
  25. Click Print

    Step 25
  26. The print area has been cleared.   All cells in the file will be printed.

    Step 26
  27. Click the Home tab.

    Step 27

After completing this topic, you can set the print area, add cells to an existing print area, and clear the print area in an Excel spreadsheet.