Lesson 83

  Back to Lessons

Office 2010 - Excel

Lesson 83: Printing “Worksheets” (1)

83/87 Lessons 

Preview

The first thing you do before you print a file is preview it through the “Print Preview” feature.
Just click the “Print Preview” button in the “Quick Access” toolbar, or if you do not have it added to this toolbar, click the “File” tab and select “Print”.

In both cases, it opens the “Print” dialog. The “Print” dialog box has several options shown in the middle of the box and a print preview option on the right.
The “Options are divided into three sections:

You have the “Print” (a) section
You have the “Printer” (b) section, where you can choose which printer you want to use.
And you have the “Settings” (c) section, which I will cover in detail

Clicking on the downward pointing arrow next to the first option (1), gives us a drop-down list where we can choose between only the “Print Active Sheets”, “Print Entire Workbook” or “Print selection”.

  • The first option will only print the “Worksheet” that is selected.
  • The second option will print all “Worksheets” in the “Workbook”.
  • And the third will only print the selected print “Range”.
    This print area is set by selecting a “Range” in the “Worksheet”. Click the “Print Range” button in the “Ribbon” and select “Print determine” in the drop-down menu.

If I have several “Worksheets” in the “Workbook” that I wish to print, I choose “Print entire workbook”.

With the second option (2) we determine the order of pages to be printed. You can give the number of prints of one or more. Here you determine the order of printing. First of all , the first pages, then all the second pages and so on, or first page one, then page two and so on.

In the third option (3) you determine the orientation, portrait or landscape.

With the fourth option (4) you determine the paper size.

In the fifth option (5), you can see the margins of the printout and the data in the page center. In the example I want a bit of everything centered nicely printed, so I click the downward pointing arrow and choose “Custom Margins” in the pop-up menu.
In the dialog that appears I select the “Margins” tab check “Horizontal” and “vertical” boxes.

With the sixth option (6), you can print any size.

The different possibilities are self explanatory.

If you have everything set as desired, you can see the result in the preview:

Awesome!
You've completed Lesson 83 START NEXT LESSON

Featured Courses