Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.5 Configure Worksheets and Workbooks to Print or Save: Set a Print Area

Page Setup: Print Area

One more example of how to select the pages or Cells that you want to print. You can use Print Area to print a specific Range if you wish.

 

8. Try This: Select Print Area

Select Cells A1:C9.
Go to
Page Layout->Page Setup->Print Area.
Select:
Set Print Area.

 

Trust But Verify: Print Preview
Go to
File->Print.

What Do You See? On the left side of the Print Preview are the Printer settings. On the right is the Print Preview. The Print Area should be the only range in this preview.

 

So far, so good. Click on the Arrow in the upper left corner of the Print Preview to return Home.

Try This, Too: Clear Print Area

Go to Page Layout->Page Setup->Print Area.
Select:
Clear Print Area.

Keep going, please...

graphic2
graphic1

Page Layout -> Page Setup ->Print Area->Set Print Area

no