by

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.

1588721070 978 How to hide or unhide columns and rows in
1588721071 657 How to hide or unhide columns and rows in

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.

1588721071 823 How to hide or unhide columns and rows in
1588721072 145 How to hide or unhide columns and rows in

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.

1588721073 664 How to hide or unhide columns and rows in
1588721073 330 How to hide or unhide columns and rows in

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.

1588721074 506 How to hide or unhide columns and rows in
1588721075 156 How to hide or unhide columns and rows in

How to unhide all the columns and rows in Excel

1588721075 99 How to hide or unhide columns and rows in

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.

1588721076 744 How to hide or unhide columns and rows in
1588721077 830 How to hide or unhide columns and rows in

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.

1588721077 574 How to hide or unhide columns and rows in
1588721078 773 How to hide or unhide columns and rows in

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

Comment

Leave a Reply

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