Be able to hide and display rows and columns

📊 20 Spreadsheets – Hide & Display Rows & Columns

Why Hide Rows & Columns? 🎯

When your spreadsheet gets crowded, hiding rows or columns is like putting a cover over a page in a book. It keeps the information you need visible while keeping the rest out of sight. This helps you focus on the data that matters and makes your sheet look tidy, just like a neat desk keeps your homework organized.

How to Hide a Row or Column 🕵️‍♂️

1. Select the row number (e.g., 2) or column letter (e.g., B) you want to hide.
2. Right‑click on the selected header.
3. Choose Hide from the context menu.
4. Notice the row or column disappears, and the numbers/letters jump together.

How to Unhide Rows or Columns 🔓

1. Click the row numbers or column letters on either side of the hidden area.
2. Right‑click and select Unhide.
3. The hidden row or column reappears, restoring the original layout.

Practical Example: 📈 Sales Data

Suppose you want to focus only on the first two months. Hide row 3 (March) by selecting it, right‑clicking, and choosing Hide. When you’re ready to see March again, unhide it the same way. You can do the same with columns – for example, hide column C (Profit) if you only need to see sales figures.

Quick Tips for Mastery 🚀

• Use Ctrl + 9 to hide rows quickly.
• Use Ctrl + 0 to hide columns quickly.
• To unhide all rows, press Ctrl + Shift + 9 (or go to Format → Row → Unhide).
• To unhide all columns, press Ctrl + Shift + 0 (or go to Format → Column → Unhide).
• Remember: hidden data is still there – you’re just not looking at it.

Fun Challenge 🎓

Create a spreadsheet with five months of data. Hide the middle month, then calculate the profit margin for the remaining months using the formula: Profit Margin = (Profit / Sales) × 100% Express the result in LaTeX: $ \text{Profit Margin} = \frac{\text{Profit}}{\text{Sales}} \times 100\% $. Check your work by unhiding the middle month and verifying the numbers.