Buzz
Are you seeking ways to hide columns and rows in Excel, but unsure of how to do it swiftly? Explore the article below to discover how to hide columns and rows in Excel 2016, 2013, 2010.
Below, the article shares methods for hiding columns, rows, showing hidden columns, and showing hidden rows in Excel 2016, 2013, 2010. Join us to learn more.
How to Hide Columns in Excel
Step 1: Start by selecting the column you want to hide.
Choose one or multiple columns to hide. If you want to hide multiple non-adjacent columns, hold down Ctrl and select the non-adjacent columns you want to hide.
Step 2: Right-click on the header of the selected columns and choose Hide to conceal them.
By doing so, you have successfully hidden the column(s). A double line between two columns signifies that the column(s) there are hidden.
How to Unhide Columns in Excel
Step 1: To unhide columns in Excel, first select the adjacent columns to the hidden ones.
Step 2: Next, right-click on the header of the selected column and choose Unhide to reveal the hidden column.
Congratulations! You have successfully unhid the column.
How to Hide Rows in Excel
Step 1: First, select the rows you want to hide.
Note: You can select one or multiple consecutive rows to hide. If you want to select non-adjacent rows, hold down the Ctrl key while selecting the rows you want to hide.
Step 2: Next, right-click on the header of the selected rows, then choose Hide to conceal them.
How to Unhide Rows in Excel
Step 1: To reveal hidden rows, select the rows before and after the hidden rows.
Step 2: Then, right-click on the header of the selected row and choose Unhide to show the hidden row.
Above, the article has guided you on how to hide columns, rows, along with displaying hidden columns and rows in Excel 2016, 2013, 2010. We hope through this article, you will be able to easily hide/unhide rows and columns in Excel. Wish you success!
