I have used the Range.Hidden property and set it False as I want to unhide the entire row. Here, I have created a Sub Procedure Unhide_Non_Adjacent_Rowsand mentioned the worksheet that I am going to work with. Worksheets("Unhide Non Adjacent Rows VBA").Range("10:10,12:12,15:15").EntireRow.Hidden = False The 10th, 12th, and 15th rows are non-adjacent and hidden.Īfter inserting a new module, write down the following code. Now, let’s see how we can unhide several non-adjacent rows in Excel. Shortcut to Unhide Rows in Excel using VBA (Non-Adjacent) Excel will unhide the 7th and 8th rows.ģ.3. Range from (“7:8”) indicates that the range starts with the 7th row and ends at the 8th row. Here, I have created a Sub Procedure Unhide_Adjacent_Rowsand mentioned the worksheet that I am going to work with. Worksheets("Unhide Adjacent Rows VBA").Range("7:8").EntireRow.Hidden = False Then write down the following code, Sub Unhide_Adjacent_Rows() To open the VBA editor and to insert a new module follow the steps explained in section 3.1.
![excel keyboard shortcut for double click excel keyboard shortcut for double click](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/04/Excel-Fill-Down.jpg)
In our dataset, 7th, and 8th, two adjacent rows are hidden. We can also unhide several adjacent rows in Excel using VBA. Shortcut to Unhide Rows in Excel using VBA (Adjacent) Range (“5:5”) indicates that the range starts and ends in the 5th row.Įxcel will unhide the 5th row in the “ Unhide a Row VBA” datasheet.ģ.2. Here, I have created a Sub Procedure Unhide_A_Rowand mentioned the worksheet that I am going to work with. Worksheets("Unhide a Row VBA").Range("5:5").EntireRow.Hidden = False Go to Developer tab > select Visual Basic To unhide a row, (the 5th row in this case)
#Excel keyboard shortcut for double click how to
Here, I am going to explain how to unhide a row using VBA. Shortcut to Unhide a Row in Excel using VBA
![excel keyboard shortcut for double click excel keyboard shortcut for double click](https://www.excelcampus.com/wp-content/uploads/2015/09/Keyboard-Shortcut-to-Ungroup-Rows-or-Columns-in-Excel.png)
I am going to describe it in this section.ģ.1. Unhide Rows in Excel in Shortcut using VBA
![excel keyboard shortcut for double click excel keyboard shortcut for double click](https://www.informatique-mania.com/wp-content/uploads/2021/04/atajo-teclado-excel_9658.jpg)
The 10th, 12th, and 15th rows will appear.ģ. Put another way, select from 9th row to 16th row. Select a range of rows where the hidden rows exist. For instance, to unhide the multiple rows (in our case it is the 10th, 12th, and 15th row), You can also unhide several non-adjacent rows following the same method. Unhide Several Non-Adjacent Rows using CTRL + SHIFT + 9 To unhide adjacent rows (in our case it is the 7th and 8th row),Ģ.3. You can also unhide several adjacent rows using CTRL + SHIFT + 9. Unhide Several Adjacent Rows using CTRL + SHIFT + 9
![excel keyboard shortcut for double click excel keyboard shortcut for double click](https://images.idgesg.net/images/article/2017/11/excel_shortcuts-0-100741077-orig.jpg)
So, I have to select the 4th and 6th row.Įxcel will unhide the 5th row, as it was in between the selected 4th and 6th row.Ģ.2. For instance, I am going to unhide the 5th row. Let’s discuss them one by one.įirst, select the rows adjacent to the row you want to unhide. Now I am going to discuss how to unhide rows in Excel using Keyboard shortcuts. Unhide Rows in Excel in Shortcut (Using CTRL + SHIFT + 9) You can easily unhide all other rows in this way.Ģ. Place your mouse point in the middle of the 4th and 6th row. You can very easily unhide a row with double clicks in Excel. We will unhide these rows using several methods.ģ Shortcut to Unhide Rows in Excel 1. You will observe that the 5th, 7th, 8th, 10th, 12th, and 15th rows are hidden here. We have a list of students along with their Hometown and Department.