🎬 Video Lecture 📊 Presentation Slides 📝 Practice Quiz 📁 Unit 4 Hub
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
📊 Slide Deck 📝 Take Quiz
⬅️ Previous Episode 🏠 Unit Overview Next Episode ➡️

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