How to Hide and Unhide Columns and Rows in MS Excel

How to Hide and Unhide Columns and Rows in MS Excel

In this article, I am going to share with you How to Hide and Unhide Columns and rows in Microsoft Excel. Below follow, all steps to know how to perform this acting in simple ways. 

How to Hide Rows and Columns in MS Excel

Step 1: The very first step is to open your excel spreadsheet where your data is stored or create rough or dummy data to perform this function.

Step 2: In this step, you need to select the row or column which you want to hide, for example in the below image I have selected that vertical line to hide or a horizontal line to hide in another picture.


Step 3: After selecting any row or column, click on the Format option in Home. After clicking on Format, click on Hide & Unhide, and in this select row or column. 

In the above image, I have selected columns so, after clicking on hiding Columns. The columns will disappear. And this will look like this.

Step 4: Follow the same steps to hide rows. 

Now, let’s see how to unhide rows and columns.

How to Unhide Rows and Columns in MS Excel

Step 1: Follow the same steps as you have followed above to hide the columns and rows. 

Step 2: After all of this, simply go to Format > Hide & Unhide > and click the Unhide Column or Row, whatever you have hidden this will appear in their respective place. 

For example, above I have hided columns and after clicking on Unhide this will look like this.

This is all steps to hide and unhide your columns and rows.

Leave a Reply

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