How to Hide and Unhide Rows in Excel (6 Easiest Ways)

To develop or sometimes to update the Excel Sheet, we often need to hide and unhide rows in Excel for our further use. In this article, we are going to discuss the 6 easiest methods to hide and unhide rows in Excel.

Here we took an Excel sheet that represents the monthly sales report for the month of February 2022, where columns B, C, D and E stand for Sales Representatives, Product ID, Product Category and Sales respectively.

hide unhide rows in excel


Download Practice Book


6 Easiest Ways to Hide and Unhide Rows in Excel

There are several methods to hide and unhide rows in Excel. In this article, we will show you how to hide and unhide both single row and multiple rows in an Excel sheet in 6 different ways.


1. Hide Rows Using Ribbon in Excel

In this method, we will discuss how to use Ribbon to hide a single row in an Excel Sheet.


1.1 Hide a Single Row Using Ribbon in Excel

For this, we have to select the row first that we want to hide. Here our desired row is row 7. Here, I will show you how to hide this row 7 using Ribbon.

hide unhide rows in excel

Next, we have to follow the following steps.

  • Open the Home tab >> go to Cells >> select Format

hide unhide rows in excel

After selecting Format, we can see some other options. Now we have to follow some further steps.

  • Click on Format >> go to Hide & Unhide >> select Hide Rows

hide unhide rows in excel

Immediately after clicking on the Hide Rows, we can see that row 7 is now hidden from the Excel Sheet.

hide unhide rows in excel


1.2 Hide Multiple Rows Using Ribbon in Excel

We can easily hide multiple rows in an Excel sheet using this method. For this, we have to select more than one row first. Here, row 9 and 10 are our desired rows that we want to hide. Now, we will hide rows 9 and 10 using Ribbon.

Next, we have to follow the following steps.

  • Open the Home tab >> go to Cells >> select Format

After selecting Format, we can see some other options. Now we have to follow some further steps.

  • Click on Format >> go to Hide & Unhide >> select Hide Rows

Immediately after clicking on the Hide Rows, we can see that both rows 9 and 10 are now hidden from the Excel Sheet.

Read More: Formula to Hide Rows in Excel (7 Methods)


Similar Readings


2. Unhide Rows Using Ribbon in Excel

In this method, we will discuss how to use Ribbon to unhide a single row in an Excel Sheet.


2.1 Unhide a Single Row Using Ribbon in Excel

We can see that our desired row 7 is missing here. Here, I will show you how to unhide this row 7 using Ribbon.

hide unhide rows in excel

To unhide our derided row in Excel, we have to select both rows first, above and below the hidden row. Here we have selected both rows 6 and 8 together.

hide unhide rows in excel

Next, we have to follow the following steps.

  • Open the Home tab >> go to Cells >> select Format

 

hide unhide rows in excelAfter selecting Format, we can see some other options. Now we have to follow some further steps.

  • Click on Format >> go to Hide & Unhide >> select Unhide Rows

 

hide unhide rows in excelImmediately after clicking on the Unhide Rows, we can see that our desired rows 7 is now shown again in the Excel Sheet.

hide unhide rows in excel

Read More: How to Unhide Rows in Excel (8 Quick Ways)


2.2 Unhide Multiple Rows Using Ribbon in Excel

We can see that our desired rows 9 and 10 are missing here. Here, I will show you how to unhide these rows 9 and 10 using Ribbon.

hide unhide rows in excel

To unhide our derided rows in Excel, we have to select both rows first, above and below the hidden row. Here we have selected both rows 8 and 11 together.

hide unhide rows in excel

Next, we have to follow the following steps.

  • Open the Home tab >> go to Cells >> select Format

hide unhide rows in excel

After selecting Format, we can see some other options. Now we have to follow some further steps.

  • Click on Format >> go to Hide & Unhide >> select Unhide Rows

Immediately after clicking on the Unhide Rows, we can see that both rows 9 and 10 are now shown again in the Excel Sheet.


Similar Readings


3. Hide Rows Using Right-Click/Context Menu in Excel

By using the mouse, we can easily hide a single row in an Excel sheet. For this, we have to select our desired row first. Here, row 8 is our desired row.

hide unhide rows in excel

After selecting our desired row, now we have to click the right button of the mouse. Then there appears a dialog box and we have to select the Hide option from that dialog box.

Immediately after clicking on the Hide option, we will find that row 8 is hidden now.


4. Unhide Rows Using Right-Click/Context Menu in Excel

By using the mouse, we can easily unhide multiple rows in an Excel sheet. We can see that our desired rows 9 and 10 are missing here. Here, I will show you how to unhide these rows 9 and 10 using a mouse only.

hide unhide rows in excel

To unhide our derided rows in Excel, we have to select both rows first, above and below the hidden row. Here we have selected both rows 8 and 11 together.

hide unhide rows in excel

After selecting our desired rows, now we have to click the right button of the mouse. Then there appears a dialog box and we have to select the Unhide option from that dialog box.

hide unhide rows in excel

Immediately after clicking on the Unhide option, we will find that both rows 9 and 10 are hidden now shown again in the Excel Sheet.

Read More: How to Unhide All Rows in Excel (All Possible Ways)


5. Hide Rows Using Keyboard Shortcut in Excel

Using the Keyboard Shortcut is another convenient method to hide a single row in an Excel sheet. Here, we don’t need to select any row, rather selecting any cell from our desired row would be enough for this. Here, we select cell B12.

hide unhide rows in excel

On the keyboard, now press and hold the CTRL key. Then without releasing the CTRL key, press and release the number 9 key.

hide unhide rows in excel

Immediately after clicking CTRL + 9, we can see that row 12 has just vanished from the Excel sheet.


6. Unhide Rows Using Keyboard Shortcut in Excel

By using the Keyboard Shortcut, we can unhide multiple rows too. Here, we can see that rows 10 and 11 are hidden here.

To unhide our derided rows in Excel, we have to select both rows first, above and below the hidden row. That’s why we have selected both rows 9 and 12 together here.

rows in excel

On the keyboard, press and hold the CTRL and SHIFT keys. Without releasing the CTRL & SHIFT keys, press and release the number 9 key.

rows in excel

Immediately after clicking CTRL + SHIFT + 9, we can see that rows 110 and 11 have just appeared in the Excel sheet again.


Recommendation

To hide and unhide rows in Excel, you have to select both the immediate before and after rows. To know more about shortcuts to unhide rows check this article Shortcuts to Unhide Rows.


Practice Yourself

I’ve given a practice sheet in the workbook to practice these explained ways to hide and unhide rows in Excel. You can download it from the link given above.

rows in excel


Conclusion

In this article, I have tried to explain 6 different methods to hide and unhide in Excel. You can also hide multiple columns using the same methods. Last but not least, I will be extremely grateful if you comment down below any of your suggestions, ideas, or feedback.


Related Articles

Foyez

Foyez

Hello everyone, This is Foyez Alam. I have recently completed my MBA from Institute of Business Administration (IBA), University of Dhaka. Earlier I have completed my B.Sc in Leather Engineering from University of Dhaka. Now I am working as an Excel and VBA Content Developer in SOFTEKO. Through patience and hard work, I have a passion for learning new things and applying my knowledge to new situations. That's why I am here. Besides this, I love to interact with different people and I love to spend my spare time reading, watching movies, dancing, etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo