How to hide or unhide columns and rows in Excel

How to hide or unhide columns and rows in Excel

How to hide or unhide columns and rows in Excel

How to hide or unhide columns and rows in Excel
In this blog post we will tell you the trick of Microsoft Excel, how to hide or unhide all the columns and rows in Excel, and all with the help of a few clicks.

How to hide or unhide all columns in excel

First of all, we will tell you how to hide or unhide columns, select the column you want to hide and right-click and then you will see an option to hide then click it. The column you selected has been hidden.

Now if you want to un-hide the column, you select the right and left columns together and then right-click, then you will see the unhide option click it now. That column is unhidden.

How to hide or unhide all rows in excel

Then we will tell you how to hide or unhide rows, select the row you want to hide and right-click, then you will see an option to hide then click it. The row you selected has been hidden.

Now if you want to un-hide the row, you select the top and bottom rows together and then right-click, then you will see the unhide option. Those rows have been unhidden.

How to unhide all the columns and rows in Excel

And if you have to un-hide multiple columns and rows, select the sheet as shown in the picture below.

And right-click on any column heading, then click the Unhide option so all the columns that are hidden in your Excel sheet will be unhidden.

Similarly, right-click on any row heading, then click the Unhide option so all the rows that are hidden in your Excel sheet will be unhidden.

After understanding the simple trick of Microsoft Excel, these questions will be solved in your mind.

How to unhide all columns in excel
How to unhide all rows in excel
How do you unhide columns in excel
How to unhide all in excel
How to unhide excel rows

Leave a Reply

Your email address will not be published. Required fields are marked *