🎬 Video Lecture 📊 Presentation Slides 📝 Practice Quiz 📁 Unit 4 Hub
Episode 4.9

MASTERING MS EXCEL BASICS

Class 10 (X) • Unit 4: Digital Data Tabulation - Spreadsheet (MS Excel)

💡 Direct Stream: You can also watch directly on YouTube or via local server: 📺 Watch on YouTube.com
Episode code: 4.9
📊 Slide Deck 📝 Take Quiz
⬅️ Previous Episode 🏠 Unit Overview Next Episode ➡️

✍️ Episode 4.9 Topic Notes

📌 A. Print Area

  • Highlight the exact rectangular range of cells required for the official report, click Print Area $\rightarrow$ Set Print Area.
  • Excel prints *only* those designated cells, completely ignoring scratch calculations and notes outside the boundary.

📌 B. Orientation & Scaling (Fit to Page)

  • Orientation: Switch wide multi-column tables to Landscape.
  • Page Scaling (Fit to Page):
  • In the *Scale to Fit* group, set Width: 1 page and Height: Automatic (or 1 page).
  • Shrinks the entire table proportionally so no columns bleed onto an orphan extra sheet.

📌 C. Print Titles (Repeating Header Rows on Multi-Page Reports)

  • Problem: When a 500-student table prints across 10 pages, pages 2 through 10 have no column headings at the top!
  • Solution: Go to Page Layout $\rightarrow$ Print Titles $\rightarrow$ click in Rows to repeat at top $\rightarrow$ select $1:$1.
  • Now Row 1 prints automatically at the summit of every single printed physical sheet!

📌 D. Printing Gridlines and Headings

  • In Page Layout $\rightarrow$ *Sheet Options*:
  • Check Print Gridlines to force cell boundary lines to print on paper.
  • Check Print Headings to print row numbers (1, 2, 3...) and column letters (A, B, C...) on paper (crucial for classroom exams and lab submissions).