When working with large complex worksheets in Excel, it is quite common to hide some rows. It helps you conceal information you may not need at that particular time. Or you may receive a spreadsheet that has some of the columns and rows hidden. With a simple mouse click, you can hide your rows. But what happens when you need to access the hidden rows? Expanding hidden rows in Excel is not easy as hiding them. Here are steps you have to expand the hidden rows in Excel.
In our guide, we discuss the different methods to expand the hidden rows in Excel. Let’s get started.
Keyboard shortcut to expand hidden rows
1. Launch your Microsoft Excel program.
2. Open the workbook that containing hidden rows.
3. select your entire workbook using the shortcut ctrl+A
4. Press the Ctrl + Shift + 9 ( at the same time to expand all the hidden rows within your workbook.)If this shortcut doesn’t work on your Excel, try Ctrl +Shift + 0
How to expand individual rows in Excel
1. Launch your Excel program and open the worksheet that contains the hidden rows.
2. Highlight the top and bottom rows on any side you want to expand.
3. Right-click on the selection to display a drop-down menu.
4. In the menu, click Unhide.
Expanding multiple rows using command tools
1. In an open Excel worksheet, click on the Home tab on the main menu ribbon.
2. Go to the Cells section and click on the drop-down arrow next to the Format option.
3. Move your cursor to the Visibility area. Here you will find various options to hide and expand columns and rows .
4. Move your cursor on Hide & Unhide option or select the option to display the options given.
5. Select Unhide Rows from the given options list. The command will show all the hidden rows in your workbook.
Expanding Excel rows by adjusting the row height
By default, all Excel rows are set at the height of 14.4. You can reset the height of all your rows, and this will automatically expand all the hidden rows.
1. Launch your Microsoft Excel program and open your worksheet.
2. Click the Select All button (triangular button) in the upper-left corner of your spreadsheet. It will select your entire worksheet. You can also use the keyboard shortcut Ctrl + A.
3. Click on the Home tab on the main ribbon.
4. In the Cells group, click Format to display a drop-down menu.
5. Under the Cell Size section, click on the option Row Height to display a pop-up window.
6. In the displayed Row Height window, type in Excel’s default row height (14.4)
7. Click on the OK button. Afterward, you will notice all your rows are visible, including the rows that were hidden via height properties.