Preparing to Print - Exercise

Contact Us or call 1-877-932-8228
Preparing to Print - Exercise

Preparing to Print

Duration: 10 to 20 minutes.

In this exercise, you will prepare your worksheet for printing.

  1. Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Preparing to Print.xlsx from your Excel2013.1/Exercises folder.
  2. Center data horizontally and vertically on the page.
  3. Set the page orientation to landscape.
  4. Set the worksheet to print on one page.
  5. Add the picture LemonadeLogo.gif, found in your Excel2013.1/Exercises folder, to the header in the center section.
  6. Save the workbook.

Solution:

  1. Open or go to the specified file.
  2. To center data horizontally and vertically on the page:
    1. On the PAGE LAYOUT tab, in the Page Setup group, click the Margins command:
    2. Select Custom Margins:
    3. In the Center on Page section, check both Horizontally and Vertically and click OK:
  3. To set the page orientation to landscape:
    1. On the PAGE LAYOUT tab, in the Page Setup group, click the Orientation command:
    2. Select Landscape:
  4. To set the worksheet to print on one page:
    1. On the PAGE LAYOUT tab, in the Scale to Fit group, set the Width and Height to 1 page:
  5. To add the logo to the header:
    1. On the INSERT tab, in the Text group, click Header & Footer:
    2. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click Picture:
    3. Surf to your Excel2013.1/Exercises folder, select LemonadeLogo.gif, and click INSERT:
  6. Save the workbook. If you print it, it should look like this:
Next