Episode 4.5
EXCEL WORKSHEET STRUCTURE
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.5
✍️ Episode 4.5 Topic Notes
📌 A. Inserting Structure
- Inserting a Row:
- Right-click any row number $\rightarrow$ select Insert (or Home tab $\rightarrow$ *Cells* group $\rightarrow$ *Insert*).
- Shortcut:
Ctrl + Shift + "+"(with row selected). - Behavior: New rows are always inserted directly above the selected row, shifting existing data downwards.
📌 A. Manual Sizing
- Drag the dividing border between row numbers vertically or column letters horizontally.
- Right-click header $\rightarrow$ Row Height... (measured in points, e.g. 15 pt default) or Column Width... (measured in character width units, e.g. 8.43 default).
📌 B. The AutoFit Feature
- Column AutoFit: Double-click the boundary line between two column headers (e.g. between column A and B). Excel instantly resizes column A to match the widest entry in that column.
- Row AutoFit: Double-click the dividing line between two row headers to snap row height to the tallest font size.
- Hiding: Right-click the row number or column letter $\rightarrow$ click Hide.
- The column disappears from screen view and printouts.