BUSINESSEDUCATIONNY
  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks

Domain 1 Lesson 3
Format Worksheets & Workbooks

Page Setup


For this worksheet, set the page margins to wide and the orientation to landscape.
  1. Click the Page Layout tab
  2. In the Page Setup group, click the Margins drop-down arrow
  3. Click Wide
  4. In the Page Setup group, click the Orientation drop-down arrow
  5. Click Landscape

Row Height & Column Width


On the current worksheet, set the row height for row 2 to 30 and the width of columns F and G to 12.
  1. Click the number 2 in the rows to select the entire row
  2. Click the Home tab (if necessary)
  3. In the Cells group, click the Format drop-down arrow
  4. In the Cell Size section, click Row Height
  5. Type: 30
  6. Click the OK button
  7. Click and drag over the letters F and G to select columns F and G
  8. In the Cells group, click the Format drop-down arrow
  9. In the Cell Size section, click Column Width
  10. Type: 12
  11. Click the OK button

Headers & Footers


Add the file name as a header to the current worksheet. Then, add the current date to the left side of the footer.
  1. Click the Page Layout tab
  2. Click the Page Setup dialog box launcher
  3. Click the Header/Footer tab
  4. Click the Header drop-down arrow
  5. Click the file name (133-classes by month.xlsx)
  6. Click the Custom Footer button
  7. Ensure the cursor is in the Left section
  8. Click the Date icon
  9. Click the OK button twice

Mr. Kazanjian's Business Class
Hempstead High School
Room A112
​[email protected]

  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks