Foyez Alam
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.
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.
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 row 7 is now hidden from the Excel Sheet.
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
- How to Hide Blank Rows in Excel VBA (4 Useful Methods)
- VBA to Hide Rows Based on Criteria in Excel (15 Useful Examples)
- VBA to Hide Rows Based on Cell Value in Excel (14 Examples)
- VBA to Hide Rows in Excel (14 Methods)
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.
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.
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 Unhide Rows
Immediately after clicking on the Unhide Rows, we can see that our desired rows 7 is now shown again in the Excel Sheet.
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.
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.
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 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
- Excel VBA: Unhide All Rows in Excel (5 Practical Examples)
- Hidden Rows in Excel: How to Unhide or Delete Them?
- Unhide All Rows Not Working in Excel (5 Issues & Solutions)
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.
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.
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.
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.
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.
On the keyboard, now press and hold the CTRL key. Then without releasing the CTRL key, press and release the number 9 key.
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.
On the keyboard, press and hold the CTRL and SHIFT keys. Without releasing the CTRL & SHIFT keys, press and release the number 9 key.
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.
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
- How to Hide Rows Based on Cell Value in Excel (5 Methods)
- Hide Rows Based on Cell Value with Conditional Formatting in Excel
- Excel Macro: Hide Rows Based on Cell Text in Excel (3 Simple Methods)
- Hide Duplicate Rows Based on One Column in Excel (4 Methods)
- [Fixed!] Excel Rows Not Showing but Not Hidden (3 Reasons & Solutions)
