? Part 1: Introduction to Page Layout

? What is Page Layout?

Page Layout controls how your worksheet:

• Appears on screen
• Prints on paper

? It ensures your data is clear, readable, and properly aligned.

? Part 2: Page Setup (Core Settings)

? Step 1: Open Page Layout Tab

• Click Page Layout tab in Microsoft Excel

? Step 2: Margins

1. Click Margins
2. Choose:
   • Normal
   • Narrow
   • Wide

? Custom margins can also be set

? Step 3: Orientation

? Step 4: Page Size

• Select:
  • A4 (standard)
  • Letter

? Part 3: Scaling & Fit to Page

? Step 5: Scaling Options

• Adjust worksheet to fit:
  • 1 page wide
  • 1 page tall

? Prevents data from splitting across pages

? Step 6: Fit Sheet on One Page

• File → Print → Scaling → Fit Sheet on One Page

? Part 4: Print Area

? Step 7: Set Print Area

1. Select data
2. Page Layout → Print Area → Set Print Area

? Only selected data will print

? Step 8: Clear Print Area

• Page Layout → Print Area → Clear

? Part 5: Print Titles (Very Important)

? Step 9: Repeat Header Row

1. Page Layout → Print Titles
2. Select row (e.g., Row 1)

? Header appears on every printed page

? Part 6: Header & Footer

? Step 10: Insert Header/Footer

1. Page Layout → Page Setup → Header/Footer
2. Add:

Header:

ICT Lab – Excel Report

Footer:

Your Name | Page 1

? Step 11: Add Page Numbers

• Use:
  • Page Number
  • Date
  • File Name

?️ Part 7: Print Preview & Printing

? Step 12: Print Preview

• File → Print
• Check:
  • Layout
  • Alignment
  • Page breaks

? Step 13: Print Settings

• Select printer
• Choose number of copies
• Print

? Part 8: Gridlines & Headings

? Step 14: Print Gridlines

• Page Layout → Gridlines → Print

? Step 15: Print Headings

• Show row/column labels

? Part 9: Page Breaks

? Step 16: Insert Page Break

1. Select row
2. Page Layout → Breaks → Insert Page Break

? Controls where page splits

? Part 10: Practical Example

? Data Table

Student Marks Sheet

Tasks:

• Set margins (Normal)
• Orientation (Landscape)
• Fit to 1 page
• Add header/footer
• Set print area
• Preview before printing

? Part 11: Best Practices

✅ Do’s

• Always check print preview
• Use landscape for wide tables
• Repeat header rows
• Keep margins balanced

❌ Don’ts

• Do not print without preview
• Avoid cutting data across pages
• Avoid cluttered layout

? Lab Practice Tasks

Students must perform:

✅ Adjust margins and orientation
✅ Set print area
✅ Add header and footer
✅ Enable gridlines
✅ Print preview

? Expected Learning Outcomes

Students will:

• Prepare Excel sheets for printing
• Design professional reports
• Control page layout effectively
• Avoid printing errors

⚠️ Common Mistakes to Avoid

• Not setting print area
• Ignoring print preview
• Wrong orientation
• Missing headers

?‍? Instructor Guidelines

• Demonstrate print preview live
• Show incorrect vs correct layout
• Check student settings
• Emphasize professional output

? Conclusion

This tutorial ensures students can create well-structured, print-ready Excel reports, a critical skill for academic and professional documentation.