In Excel for Microsoft 365 on Windows, select the full rows that include the hidden rows, then press Ctrl+Shift+9 to unhide them. You can make that selection without a mouse by entering a row range such as 4:8 in the Name Box and pressing Enter. This guide explains how to choose the right range, use the shortcut, and handle cases where rows are filtered, grouped, or protected instead of simply hidden.
What You’ll Need
- An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
- The row numbers or approximate location of the hidden rows. You do not need to know every hidden row number if you can select a range that covers them.
- Permission to change the worksheet. A protected sheet may prevent you from changing row visibility.
The shortcut works best when the selection includes entire rows, not just cells inside the rows. The Name Box, just to the left of the formula bar, is a convenient way to select full rows using only the keyboard. If you use Excel for Mac, see the platform note in the steps; the equivalent shortcut uses Command rather than Ctrl.
Step-by-Step
- Open the worksheet and locate the hidden section. Look at the row numbers along the left edge of the sheet. If the numbering jumps from 6 to 10, for example, rows 7, 8, and 9 are hidden. A double line or a small gap between row headers can also indicate hidden rows. You only need to identify a range that includes the missing rows; selecting extra visible rows around them is fine.
- Click the Name Box, or move to it with the keyboard. The Name Box is the small field to the left of the formula bar, often showing the active cell address such as A1. To reach it without using the mouse, press Ctrl+G to open Go To, then press Esc to close that dialog and return focus to the worksheet; alternatively, use the keyboard navigation supported by your Excel setup to focus the Name Box. If keyboard focus is difficult to track, clicking the Name Box is a simple way to continue while still using the shortcut to unhide.
- Enter a full-row range that includes the hidden rows. Type the first and last row numbers separated by a colon. For example, enter
4:8to select entire rows 4 through 8. If rows 5 through 7 are hidden, that selection includes the visible boundary rows and the hidden rows between them. Press Enter. Excel should highlight the selected rows, even though some of their row headers were not visible before. - Run the unhide shortcut. Press Ctrl+Shift+9 on a Windows keyboard. On some keyboard layouts, the number 9 requires the Shift key to type a different character, but the intended command is the shortcut associated with Ctrl+Shift and the 9 key. If your keyboard layout intercepts that combination, use the ribbon method below. The selected hidden rows should become visible, and the row numbers should appear in sequence again.
- Check that the right rows returned. Look at the row headers and confirm that the missing numbers are now present. If only some rows reappear, select a wider full-row range and repeat the shortcut. For instance, if you expected rows 5 through 7 but only row 5 is visible, selecting
4:10and unhide again can catch a separate hidden section or an unexpected selection boundary. - Use the ribbon from the keyboard if the shortcut is unavailable. On Windows, press Alt, then follow the KeyTips for Home > Format > Hide & Unhide > Unhide Rows. In many Microsoft 365 Windows installations the sequence is Alt, H, O, U, R; press the keys one after another, not all at once. KeyTips can vary slightly with the Excel build or language, so follow the letters displayed on screen. The selected rows still need to include the hidden rows.
- Use the Mac equivalent when working in Excel for Mac. Select the full rows that cover the hidden ones, then press Command+Shift+9. If that shortcut is unavailable on your Mac or conflicts with a system setting, use Excel’s ribbon or menu command for unhide rows instead. On Excel for the web, keyboard shortcuts and browser key handling can differ; if the shortcut does not respond, use the Home formatting controls to unhide rows.
- For a hidden first row, select it by reference. Row 1 cannot be selected by clicking a row above it because no row exists above it. Enter
1:3in the Name Box and press Enter, then use the unhide shortcut. The same principle applies to the last worksheet row: select a range that includes it by entering a valid row reference in the Name Box.
For a simple case where the hidden rows are between visible rows, you can also select both boundary row headers with the mouse and press the shortcut. For example, select row 4 and row 8 when rows 5 through 7 are hidden. However, if you want a keyboard-first approach, typing 4:8 in the Name Box is more direct and selects the whole rows rather than a few cells.
Common Mistakes
Selecting cells instead of whole rows: Highlighting A4:A8 selects cells in column A, not the complete rows. In many cases Excel needs the row headers or a full-row reference to apply the row visibility command reliably. Enter 4:8, not A4:A8, in the Name Box when you mean rows 4 through 8.
Selecting only the visible row below the gap: The shortcut cannot infer which preceding rows you intend to restore if the selection does not include them. Include rows above and below the gap, or type a range that covers the entire missing section. It is safe to include visible boundary rows; Excel does not need to hide or change them to restore the hidden ones.
Pressing Ctrl+9 instead: Ctrl+9 hides selected rows on Windows. To reverse that action, use Ctrl+Shift+9. Check which keys you pressed before trying several other commands, especially if the row numbers disappear rather than return.
Assuming every missing row is manually hidden: A filter can hide records that do not match its criteria, and an outline can collapse grouped rows. The unhide command does not clear a filter or expand a group. Check for filter arrows in the headers and outline controls such as plus and minus buttons beside the row numbers.
Expecting the shortcut to bypass sheet protection: If the worksheet is protected, Excel may block row-formatting changes. The shortcut does not override the protection. Ask the workbook owner for permission or for the sheet to be unprotected before changing row visibility.
Confusing a narrow row with a hidden one: A row may have a very small height without being fully hidden. If the row numbers are present but the contents are hard to see, select the affected full rows and use Home > Format > Row Height to set a visible height. The unhide command may not fix a row whose height is merely too small.
Tips
- Use a generous range when unsure. Selecting
1:20can restore hidden rows anywhere in the first twenty rows. Visible rows in the selection remain visible. For a large sheet, use a smaller range near the gap so it is easier to verify the result. - Remember the row-reference format. A colon between row numbers, such as
12:18, selects complete rows. A cell reference such asA12:A18selects only cells in column A. This distinction is useful for other row-level operations too. - Keep a keyboard fallback available. If the shortcut does not work because of a regional keyboard layout, focus conflict, or remote desktop, use the Home tab’s Format menu and choose the unhide-rows command. It performs the same operation without relying on the key combination.
- Check for multiple causes. A worksheet can have both manually hidden rows and a filter or collapsed outline. Unhide the manually hidden rows first, then clear or adjust the filter and expand any groups if records are still missing.
- Undo if the selection was wrong. Unhiding rows is a worksheet formatting change and can normally be reversed with Ctrl+Z on Windows or Command+Z on Mac. If the result is unexpected, undo promptly, select the intended full-row range, and try again.
Troubleshooting
The shortcut does nothing. First confirm that Excel has focus and that you selected full rows containing the hidden ones. Try a range such as 4:10 in the Name Box rather than selecting a cell range. Then retry Ctrl+Shift+9. If it still does nothing, use the ribbon route, since keyboard layouts and system or remote-desktop shortcuts can intercept key combinations.
The row numbers still skip after using Unhide Rows. Check whether the missing records are filtered out. Open the filter drop-down for the relevant column and clear the filter, or use Data > Clear to clear filters from the range. If the rows are grouped, use the outline plus button to expand the group. These actions reveal rows by changing the filter or outline state, not by changing the hidden-row setting.
The unhide command is dimmed or Excel refuses to change the rows. Check whether the worksheet is protected. On Windows, look for Review > Unprotect Sheet; if a password is requested, you need the password or help from the workbook owner. Also confirm that the workbook is not in a restricted editing state and that the selection includes the affected rows.
You cannot find the Name Box. It sits immediately to the left of the formula bar. If the formula bar or ribbon is collapsed, expand the relevant interface area or click the small address field above the grid. You can also select a row range from the Go To dialog by pressing Ctrl+G and entering a valid row reference such as 4:8; if your Excel build accepts that reference there, press Enter to select it and then use the unhide command.
Only some of the expected rows become visible. There may be more than one hidden block, or the chosen range may not cover the whole area. Enter a broader range that spans the entire section, such as 1:30, and use Unhide Rows again. Then inspect filters and outline controls separately. If row numbers appear but content is still not visible, adjust the row height instead.
Frequently Asked Questions
What is the keyboard shortcut to unhide rows in Excel?
In Excel for Microsoft 365 on Windows, select the full rows that include the hidden rows and press Ctrl+Shift+9. On a Mac, the usual equivalent is Command+Shift+9.
Can I unhide rows without using a mouse?
Yes. Enter a full-row reference such as 4:8 in the Name Box and press Enter, then use the unhide shortcut. You can also use Excel’s KeyTips to reach the Home tab’s Format and Unhide Rows commands.
How do I unhide the first row in a worksheet?
Type 1:3 in the Name Box, press Enter, and use Ctrl+Shift+9 on Windows. Since row 1 has no row above it, selecting it through a row header is not practical; the row reference avoids that problem.
Why does Ctrl+Shift+9 not reveal filtered rows?
Filtered rows are excluded by the filter rather than manually hidden. Clear or change the filter using its drop-down, or use Data > Clear. If the rows are part of a collapsed outline, expand the group instead.
Will unhide rows change the data in them?
No. Unhiding changes row visibility, not the values or formulas stored in the cells. The data becomes visible again, unless a filter, outline, protection setting, or formatting issue is still affecting what you see.
Can I unhide every row at once?
Yes. Select the whole worksheet using the Select All button at the top-left of the grid, or press Ctrl+A while the worksheet is active, then use the unhide-rows command. Be aware that this changes visibility for all manually hidden rows on that sheet, not just one section.
Related
- How to Shuffle Sheets in Excel With a Keyboard Shortcut
- How to Show Negative Numbers in Brackets in Excel
- How to Share Excel in Real Time and Co-Edit Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Won’t Group Columns? Causes and FixesIf Excel will not group columns, select the column headers you want to fold, then choose Data >…
- How to Find and Clear a Circular Reference in ExcelTo clear a circular reference in Excel, find the flagged cell using Formulas > Error Checking > Circular…
- How to Hyperlink in Excel for the Web, Step by StepTo add a hyperlink in Excel for the web, select a cell, choose Insert > Link (or press…
- Count Excel Cells by Color: Practical MethodsExcel has no built-in COUNTBYCOLOR function. For a quick count in Microsoft 365 for Windows, filter the column…
- Single Space vs Double Space in Word: Rules and SettingsIn Microsoft Word, use single spacing for compact everyday documents and double spacing when a teacher, publisher, or…
- SUMIF Checkbox in Google Sheets: Sum Checked RowsIf your checkboxes are in A2:A20 and the values to add are in B2:B20, use =SUMIF(A2:A20,TRUE,B2:B20) to total…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.