To unhide rows in Excel for Microsoft 365 on Windows, select the visible row headers immediately above and below the hidden rows, then press Ctrl+Shift+9. To reveal every hidden row on the sheet, select the whole worksheet first and use the same shortcut. You can also use the ribbon if the key combination is inconvenient. Save or open the worksheet you need; no add-in or special setup is required.
What You’ll Need
- A workbook open in desktop Excel for Microsoft 365 on Windows, or Excel for the web if you prefer its ribbon controls.
- Permission to change the worksheet. A protected sheet may prevent you from changing row visibility.
- A keyboard with the Ctrl, Shift, and number-row 9 keys. On some keyboard layouts, the shortcut is shown as Ctrl+Shift+( because the opening parenthesis shares the 9 key.
Step-by-Step
- Identify which rows are hidden. Look at the row numbers along the left edge of the sheet. If the labels jump, such as from 6 to 10, rows 7 through 9 are hidden. A small double line between row numbers can also mark a hidden row. Make sure you are looking at the correct worksheet tab before changing anything.
- Select the rows that surround the hidden section. Click the row number immediately above the hidden rows, hold Shift, and click the row number immediately below them. For example, if rows 7 through 9 are hidden, select row headers 6 and 10. Excel selects the full range, including the hidden rows in between. You can also drag across the visible row headers that bound the hidden section. Do not select only a cell in one visible row if you are unsure whether the selection includes the hidden rows.
- Use the Windows shortcut. With the surrounding rows selected, press Ctrl+Shift+9. Use the 9 on the main number row of the keyboard if the numeric keypad does not work. Excel should restore the hidden rows immediately, and their row numbers will appear in sequence again. On some layouts, you may see the command described as Ctrl+Shift+(; that refers to the same key combination on a keyboard where Shift+9 produces an opening parenthesis.
- Check the result before moving on. Look at the row labels and confirm that the missing numbers have returned. If you selected a larger range, only hidden rows within that selection should be restored. The shortcut changes visibility; it does not erase or recalculate the cells in those rows.
- Unhide all rows if you cannot locate every hidden section. Click the Select All button at the top-left corner of the worksheet, where the row and column headings meet. Then press Ctrl+Shift+9. This applies the unhide command to the entire sheet. Be careful: it can reveal rows that another person intentionally hid, so use it when you want all rows visible rather than just one section.
- Use the Name Box for a known range. If the hidden area is difficult to select on screen, click the Name Box to the left of the formula bar, type a cell range that covers it, such as A6:A10, and press Enter. Then press Ctrl+Shift+9. The selected cells span the relevant row numbers, even if some of those rows are currently hidden. For multiple separated areas, repeat the selection and shortcut, or select the entire sheet.
- Use the ribbon as an alternative. Select the affected row range or the whole sheet. Go to Home > Cells > Format > Hide & Unhide > Unhide Rows. This is the clearest method if you forget the shortcut or your keyboard layout does not send the expected keys. The command is also useful when keyboard shortcuts are intercepted by another application.
- On a Mac, use the Mac shortcut or menu. In Excel for Mac, select the surrounding row headers and press Command+Shift+9. Keyboard layouts and Excel settings can affect how symbol-based shortcuts behave, so use the menu if that combination does not respond: choose Format > Row > Unhide where available, or use the Home tab’s row-format controls. In Excel for the web, shortcut behavior can vary by browser; select the rows and use the Home ribbon’s Format options if the key combination is unavailable.
Common Mistakes
Selecting only one visible row is a frequent cause of no change. Excel needs a selection that includes the hidden rows. Select the row headers above and below the gap, not just a cell in the row above it. For a small gap, selecting the two boundary row numbers with Shift held is usually the simplest approach.
Confusing hidden rows with filtered-out rows can lead to the wrong command. A filter temporarily removes matching records from view; it does not necessarily hide them using the row Hide command. If a filter is active, use the filter arrow in the column heading and choose an appropriate clear or select-all option. In Excel, you can also use Data > Clear to clear filters on the current range or table. The rows should reappear when the filter no longer excludes them.
Using Ctrl+9 instead of Ctrl+Shift+9 hides rows. Ctrl+9 is the Windows shortcut for hiding selected rows, so pressing it by mistake can make the selection disappear. Use Ctrl+Shift+9 to reverse that action. If the wrong rows were hidden, select a range that spans them and unhide them.
Assuming the shortcut changes row height or data is another misunderstanding. Unhide restores visibility, not deleted content. If the rows still look missing, they may have a very small height, be filtered, or belong to a collapsed outline group. Check those possibilities rather than repeatedly pressing the shortcut.
Tips
For a single hidden block, include the visible row immediately above and the visible row immediately below it in your selection. For instance, if the labels go from 14 to 20, selecting rows 14 through 20 and running the shortcut reveals rows 15 through 19. You do not need to select every row in the worksheet when you know exactly where the gap is.
When you are preparing a workbook for someone else, unhide only the rows they need to see. Hidden rows can contain working notes, calculations, or information that affects how the sheet is understood. Revealing everything may make a worksheet easier to inspect, but it can also make a carefully organized report harder to read.
If you often use the shortcut, remember the pair: Ctrl+9 hides selected rows, while Ctrl+Shift+9 unhides rows in the selected range. On a Mac, the corresponding row shortcuts generally use Command in place of Ctrl. Because external keyboards and language layouts vary, the ribbon command is a dependable fallback. Excel’s ribbon path is also easier to communicate to a colleague who uses a different platform.
Before making broad changes, consider whether you are working in a shared or important workbook. Unhiding rows does not normally alter cell values, but it changes the sheet’s presentation for other users of that file. If the workbook has been deliberately formatted, note which sections were hidden so you can restore the original layout if needed.
Troubleshooting
The shortcut does nothing: First check that the selection spans the hidden rows, then try the ribbon command at Home > Cells > Format > Hide & Unhide > Unhide Rows. On Windows, use the number-row 9 rather than the numeric keypad, and make sure you are holding Shift while pressing 9. If you are using a browser, another app or browser shortcut may intercept the keys, so use the ribbon instead.
The rows are still missing after choosing Unhide Rows: Check whether the sheet is protected. Go to Review > Unprotect Sheet if that command is available and you are authorized to unprotect it; a password may be required. Then select the affected rows and try Unhide Rows again. Do not try to bypass a password if you do not have permission to change the sheet.
The row numbers return, but the rows look blank or almost invisible: Select the affected range, then go to Home > Cells > Format > Row Height and enter a suitable positive height. You can also choose Home > Cells > Format > AutoFit Row Height. This addresses rows whose height was set extremely small rather than rows hidden through the usual Hide command.
A plus sign or outline control appears beside the row numbers: The rows may be collapsed in a grouped outline rather than manually hidden. Click the plus sign next to the group to expand it. You can also use the outline level buttons near the top-left of the sheet to show a broader level of detail. Unhide Rows may not expand a collapsed group because outlining is a separate feature.
Some rows reappear but others do not: There may be more than one hidden block, or an active filter may still be excluding records. Repeat the selection-and-unhide process for each gap, then check filter arrows in the header row. If you need a complete view, select the whole worksheet and unhide all rows, then clear any filters that should no longer apply.
Frequently Asked Questions
What is the shortcut to unhide rows in Excel on Windows?
Press Ctrl+Shift+9 after selecting the rows above and below the hidden section. To reveal all hidden rows on that worksheet, select the whole sheet first and use the same shortcut.
Can I unhide rows without selecting the rows around them?
Yes. Click the Select All button at the top-left of the worksheet, then use Ctrl+Shift+9 or choose the ribbon’s Unhide Rows command. This reveals all manually hidden rows on that sheet, not just one section.
Does Ctrl+Shift+9 work in Excel for the web?
Shortcut support can depend on your browser and keyboard settings. If it does not work, select the relevant rows and use the Home tab’s Format menu to choose Unhide Rows. The ribbon method does not rely on the browser recognizing the key combination.
What is the Mac shortcut for unhiding rows?
In Excel for Mac, try Command+Shift+9 with the relevant rows selected. If your keyboard layout or settings prevent it from working, use the Format menu or the Home tab’s row-format controls instead.
Why does Unhide Rows not bring back filtered records?
Filtering and manual row hiding are different. Clear or adjust the active filter using its column arrow or Data > Clear. If rows remain missing afterward, check for manual hiding, a collapsed outline, or a very small row height.
Will unhiding rows restore deleted information?
No. Unhide only changes whether existing rows are visible. If cells or rows were deleted, use Undo if the action is still available, or restore an earlier workbook version or backup. Unhiding cannot recover deleted content.
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
- Power Query Hyperlinks: How to Create and Keep ThemPower Query can import and transform a URL, but it does not turn that text into a clickable…
- Excel Web Keyboard Shortcuts: Essential Keys and TipsExcel for the web supports many of the familiar Excel keyboard shortcuts: use Ctrl+C, Ctrl+V, and Ctrl+Z on…
- How to Delete a Random Page in WordTo delete a random page in Microsoft Word, click anywhere on that page, press Ctrl+G on Windows, enter…
- Google Sheets SUMIF: How to Exclude Subtotal Rows SafelyTo keep subtotal rows out of a Google Sheets SUMIF result, add a row-type column such as “Detail”…
- How to Freeze One Column in Excel While You ScrollTo keep Excel’s first column visible while you scroll sideways, choose View > Freeze Panes > Freeze First…
- Google Sheets SUMIF: Syntax, Examples, and Common FixesTo add values in Google Sheets only when matching cells meet a condition, use SUMIF. For example, if…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.