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
✍️ 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).