Random Video

4 Ways to hide a row - Excel Tips and Tricks

2025-05-16 0 Dailymotion

There are 4 ways to hide your row from view.

Method 1 - Hide row
1) Select cell to hide
2) Ctrl + 9

Method 2 - Change font colour
1) Highlight row
2) Home ~ Font
3) Select font colour to white

Method 3 - Custom number formatting
1) Highlight row
2) Ctrl + 1
3) Number tab
4) Custom
5) ;;; (three semicolons)
6) OK

Method 4 - Group row
1) Select cell to hide
2) Shift + Space
3) Shift + Alt + Right Arrow
4) Click on dash (-) to hide row.


How to Lock Cells that have Formulas in Excel 🔒 - Excel Tips and Tricks
https://youtube.com/shorts/opkVsvVULnY?feature=shares


group row, hide row, change font color,
how to hide rows in excel,excel hide columns with,how to unhide rows in excel,how to hide and unhide rows in excel,how to hide multiple rows in excel,excel rows not showing but not hidden,how to unhide columns in excel,