Common questions about Hide Rows and Columns usually involve formulas, shortcuts, hidden markers, and printing behavior; this FAQ includes 4 common questions and 3 glossary terms.
FAQ
Will SUM results change after I hide rows or columns?
- After hiding rows or columns, check the related formula results in the worksheet.
- Confirm that hiding changes only the display and does not remove the underlying data.
- If you need to exclude certain values from calculations, adjust the formula range or use a conditional function.
What should I do if shortcut keys do not hide rows or columns?
- Make sure you selected the full row or full column first.
- Check whether another app is using the same shortcut.
- If the shortcut does not work, use the right-click menu and select Hide directly.
Why can’t I tell where the hidden rows or columns are?
- Look for a double-line marker between row headers or column headers.
- Select the adjacent rows or columns on both sides of that marker.
- Right-click and choose Unhide, or select the whole worksheet and restore everything at once.
Will hidden rows or columns appear when I print the worksheet?
- Preview the worksheet before printing.
- Check whether the hidden area is still hidden.
- In normal use, hidden rows and columns do not appear in the printed result.
Glossary
| Term | Definition |
|---|---|
| Row header | The numbered label on the left side of a worksheet that identifies each row. |
| Column header | The lettered or labeled marker at the top of a worksheet that identifies each column. |
| Unhide | The action used to make previously hidden rows or columns visible again. |