2.4 Preparing to Print

Learning Objectives

  1. Review and learn new cell formatting techniques.
  2. Understand how to modify page scaling and margins.
  3. Create custom headers and footers to automatically update information.

In this section, we will review some of the formatting techniques covered in Chapter 1, as well as learn some new techniques. We will also preview a two-page worksheet and set page setup options to present the data in a professional manner. A new data file will be used in this section.

Formatting Worksheet Data

Data File: Continue working with CH2 Personal Budget

You have been given sales data that needs to be formatted in a professional manner. This worksheet will be printed and presented to investors, so it needs to be prepared for printing as well. Figure 2.42 shows how the finished worksheet will appear in Print Preview.

Figure 2.42 Completed Prepare to Print worksheet

 

    1. Switch to the Prepare to Print worksheet.
    1. To change the font of the entire worksheet, click the Select All button in the top left corner of the worksheet grid (see Figure 2.43).
      Select All button is in top left corner where column A and Row 1 originate, or Keyboard: CTRL A
      Figure 2.43 Select All button
  1. Change the font to Calibri, Size 12.
  2. Using the skills learned in Chapter 1, make the following formatting changes:
    1. A1:H1 – Merge and Center; format text as bold and apply a font color and size of your choice
    2. A2:H2 – Merge and Center; format text as bold and italic, apply a font color of your choice
    3. A5:H5 – Apply a dark fill color; format text as white and bold
    4. C5:H5 – Center align
    5. A15:H15 – Apply Top Border to the cells; format text as bold
    6. C6:H6 and C15:H15 – Apply Accounting Number format with 0 decimal places
    7. C7:H14 – Apply Comma style with 0 decimal places
    8. Highlight A6:A14 (salespeople’s names) and click the Increase Indent button in the Alignment group on the Home ribbon (see Figure 2.44). This will indent the text from the cell border.
Increase indent in alignment menu. Keyboard: CTRL ALT tab
Figure 2.44 Increase Indent button

Using Page Setup Options

Once the worksheet is professionally formatted, you need to look in Print Preview to see how the pages will print.

  1. Go to Backstage View by clicking the File tab on the ribbon. Select Print from the menu. Notice that the worksheet is currently printing on two pages, with the page breaking between the April and May columns. To fix this problem, you will first change the left and right margins while still in Print Preview
    Excel for Mac icon Mac Users should click the File menu option and select Print from the menu
  2. Click the Margins drop-down arrow in the Settings section (see Figure 2.45)
  3. Select Custom Margins… at the bottom of the list.
    Excel for Mac icon Mac Users should select “Manage Custom Margins”
  4. Type in 0.5 for the Left Margin and 0.5 for the Right Margin.
  5. Click OK. Changing the margins brought the May column onto the same page, but the June column is still on a separate page. Next you will use Page Scaling to fix this while still in Print Preview.
  6. Click the Scaling drop-down arrow in the Settings section (Figure 2.46).
    Excel for Mac icon Mac Users: there is no “Scaling drop-down arrow”. Just click the checkbox for “Scale to fit”
  7. Select Fit All Columns on One Page.
  8. Exit Backstage View.
Press Ctrl + P to reach Print Preview, then tab to settings for pages to print, collation, orientation, paper size, margins, and scaling.
Figure 2.46 Settings section of Print Preview

Creating a Footer using Page Setup

Now that the entire worksheet is printing on one page, you need to add a footer with information about the date the file was printed along with the filename. In Chapter 1 you learned how to create headers and footers using the Insert ribbon. You can also create headers and footers using the Custom Header/Footer dialog box.

  1. Click the Page Layout tab on the ribbon.
  2. Click the dialog box launcher in the Page Setup group. A window similar to Figure 2.47 should appear.
    Excel for Mac icon Mac Users: there is no “dialog box launcher”. Just click the Page Setup buttonPage Setup Button for Excel for Mac and continue with Step 3 below.

    Open Page Setup dialog (F6, P, S, P), then use right arrow to reach Header/Footer tab. Type Alt + U to press the Custom Footer button.
    Figure 2.47 Page Setup Dialog Box
  3. Click the Header/Footer tab in the Page Setup dialog box.
  4. Click the Custom Footer button. The Footer dialog box should appear (see Figure 2.48).
    Custom Footer dialog box with row of buttons to insert information into three text areas below: Left section (Alt + L), Center section (Alt + C), Right section (Alt + R).
    Figure 2.48 Footer Dialog Box
  5. Click in the Left section: box and type Printed on.
  6. Making sure to leave a space after the word on, click the Insert Date button.
  7. Click in the Right section: box and type Filename:.
  8. Making sure to leave a space after the colon, click the Insert File Name button.
  9. The Footer dialog box should look like Figure 2.49.
  10. Click the OK button. Click OK again to close the Page Setup dialog box.
  11. Go to Print Preview to see that the current date and file name are displayed in the footer.
  12. Exit Backstage View. Check the spelling on all of the worksheets and make any necessary changes.
  13. Save the CH2 Personal Budget file.
  14. Compare your work with the completed worksheet shown in Figure 2.42 and then submit the CH2 Personal Budget workbook as directed by your instructor.
Completed Custom Footer dialog box. Left section contains "Printed on &[Date]", Center section empty, Right section contains "Filename: &[File]".
Figure 2.49 Completed Custom Footer Dialog Box

Key Takeaways

  • It is important to always check your workbooks in Print Preview to ensure that the data is printed in a professional and easy to read manner.
  • Adjust margins and page scaling as needed to keep columns of data together on one page if possible.
  • Use headers and footers to display information in the top and bottom margins of the printed worksheet. Use the Insert buttons to insert changing information, such as dates and file names, instead of typing them in directly.

Attribution

“2.4 Preparing to Print” by Julie Romey, Portland Community College is licensed under CC BY 4.0

License

Icon for the Creative Commons Attribution 4.0 International License

Beginning Excel 2019 Copyright © 2023 by Noreen Brown; Barbara Lave; Hallie Puncochar; Julie Romey; Mary Schatz; Art Schneider; and Diane Shingledecker is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.