Interactive Tutorial
How to Hide Columns and Rows in Excel
4.9 out of 5 on G2
Practice live in your browser. No software required.
4 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can hide rows and columns in a worksheet from view. Data isnβt deleted, but simply hidden until it is unhidden again.
You can easily hide whole rows or columns from view.
Right-click the selected row(s) or column(s) and select Hide from the contextual menu.
The selected row(s) or column(s) are hidden from view.
Right-click the selected row(s) or column(s) and select Unhide from the contextual menu.
The data reappears once again.