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:Margins in Page Setup Group of Page Layout Tab
    2. Select Custom Margins:Custom Margins
    3. In the Center on Page section, check both Horizontally and Vertically and click OK:Page Setup Dialog Box
  3. To set the page orientation to landscape:
    1. On the PAGE LAYOUT tab, in the Page Setup group, click the Orientation command:Orientation in Page Setup Group of Page Layout Tab
    2. Select Landscape:Orientation Options
  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:Print Scaling
  5. To add the logo to the header:
    1. On the INSERT tab, in the Text group, click Header & Footer:Header and Footer in Text Group of Insert Tab
    2. On the Header & Footer Tools Design tab, in the Header & Footer Elements group, click Picture:Picture in Header and Footer Elements Group
    3. Surf to your Excel2013.1/Exercises folder, select LemonadeLogo.gif, and click INSERT:Insert Picture Dialog Box
  6. Save the workbook. If you print it, it should look like this:Print Preview
Next