Uploaded March 2025 | Updated September 2026, 2 weeks ago
How to see hidden rows and columns in Excel?
Are you tired of struggling to manage your Excel sheets when rows or columns get in the way?
In today’s video, we’re diving deep into how you can easily hide or show rows and columns in Excel. Let’s dive into the steps now.
Hiding Rows or Columns
1. Open your Excel file and select the row or column you want to hide.
2. Right-click on the selection and choose "Hide" from the context menu.
Showing Hidden Rows or Columns
1. To unhide, select the range of Rows or columns around the hidden ones.
2. Right-click on the selection and choose "Unhide" from the context menu.
Using Shortcut Keys
1. To hide, select rows or columns and press Ctrl + 9 (rows) or Ctrl + 0 (columns).
2. To unhide, select the range of rows or columns and press Ctrl + Shift + 9 (rows) or Ctrl + Shift + 0 (columns).
By following these steps, you can easily control how your Excel sheet appears and works for you.
Please Like this video and subscribe to our channel for more helpful tech tips on Windows.
Thanks for watching!
How to see hidden rows and columns in Excel?
Are you tired of struggling to manage your Excel sheets when rows or columns get in the way?
In today’s video, we’re diving deep into how you can easily hide or show rows and columns in Excel. Let’s dive into the steps now.
Hiding Rows or Columns
1. Open your Excel file and select the row or column you want to hide.
2. Right-click on the selection and choose "Hide" from the context menu.
Showing Hidden Rows or Columns
1. To unhide, select the range of Rows or columns around the hidden ones.
2. Right-click on the selection and choose "Unhide" from the context menu.
Using Shortcut Keys
1. To hide, select rows or columns and press Ctrl + 9 (rows) or Ctrl + 0 (columns).
2. To unhide, select the range of rows or columns and press Ctrl + Shift + 9 (rows) or Ctrl + Shift + 0 (columns).
By following these steps, you can easily control how your Excel sheet appears and works for you.
Please Like this video and subscribe to our channel for more helpful tech tips on Windows.
Thanks for watching!










