Hidden rows in Excel are a common source of confusion when spreadsheets arrive from colleagues or when previous edits have left rows tucked out of sight. Whether you've inadvertently hidden rows yourself, received a workbook with hidden data, or are troubleshooting a report that seems incomplete, knowing how to unhide rows quickly is one of those essential Excel skills that pays back many times over throughout a working week.

This guide walks through every method available for unhiding rows in modern versions of Excel, from a single hidden row to the entire worksheet at once. The instructions apply to Excel 365, Excel 2019, Excel 2021, and Excel for the web, with notes where keyboard shortcuts or menu options differ between versions. The methods discussed work consistently across Windows, macOS, and the browser-based experience, with minor variations noted along the way.

Before unhiding rows, it helps to understand why rows get hidden in the first place. Rows can be hidden manually by right-clicking and selecting Hide, by using the Format menu under the Home ribbon, or programmatically through filtering, grouping, and outlines. Each hiding mechanism has a corresponding unhide approach, and recognising which mechanism is at work helps you choose the most direct method to reveal the missing data.

Throughout this guide we cover every situation you're likely to encounter in real Excel files, from the simple case of a single hidden row in the middle of a sheet to more complex scenarios involving the very first row, protected worksheets, filtered data ranges, grouped outlines, and the rare Very Hidden state that can only be set or cleared through Visual Basic for Applications. Each method is explained with the exact key combinations, menu paths, and clicks required so you can pick whichever approach suits the workbook you're dealing with.

The fastest way to unhide a regular hidden row is the right-click menu. Select the row immediately above and the row immediately below the hidden row by clicking and dragging across their row numbers in the leftmost column of the worksheet. Right-click anywhere within the highlighted row numbers and choose Unhide from the context menu. Excel reveals all hidden rows that fall between the two selected rows, regardless of how many consecutive rows were hidden.

If multiple non-consecutive groups of rows are hidden throughout the worksheet, repeat this process for each group, or simply select all rows at once with Ctrl + A and use a single Unhide command to reveal everything. The right-click method is universally available across all Excel versions and works the same way on Windows and Mac. Many experienced Excel users default to this approach for its speed and reliability across different workbook situations. The right-click menu in Excel is context-aware, meaning the available options change depending on what you've selected.

When row numbers are highlighted, options including Hide and Unhide appear; when columns are selected, you'll see column-specific options instead. This contextual behaviour means you don't have to remember separate menus for rows and columns — the same right-click gesture works for both as long as you've correctly selected the appropriate row or column headers first. If Unhide is greyed out in the menu, double-check that you have actually selected adjacent row numbers (not cells within the rows) and that no worksheet protection is preventing the change.

The keyboard shortcut for unhiding rows in Excel is Ctrl + Shift + 9 on Windows and Cmd + Shift + 9 on Mac. To use the shortcut, first select rows on both sides of the hidden row by clicking and dragging across the row numbers, then press the key combination. Excel immediately reveals the hidden rows between the selected rows. This shortcut is significantly faster than navigating through menus and becomes second nature with regular use.

For unhiding columns, the equivalent shortcut is Ctrl + Shift + 0, though this shortcut conflicts with a Windows keyboard layout setting in some regional configurations and may not work without first adjusting Windows language settings. If the column shortcut doesn't function on your system, navigate to Windows Settings → Time & Language → Language → Advanced Keyboard Settings and uncheck the option that uses Ctrl + Shift + 0 for input language switching. Alternatively, use the right-click method, which always works regardless of system settings.

The Home ribbon provides a menu-based approach that avoids keyboard shortcuts altogether. After selecting rows surrounding the hidden rows, click the Home tab, then click Format in the Cells group, then hover over Hide & Unhide in the dropdown, then click Unhide Rows. This method takes more clicks than the right-click approach but uses visible menu items that are easier to discover for newer Excel users learning their way around the application.

Many people who switch between Excel versions or who use both Excel for Windows and Excel for Mac find the ribbon-based approach more reliable than keyboard shortcuts because the menu paths remain largely consistent across versions while shortcuts sometimes differ. The Format menu in the Home ribbon also offers other useful options including row height adjustment, column width changes, default cell formatting, and worksheet visibility settings, making it a useful menu to be familiar with beyond just the unhide function.

The trickiest unhide scenario involves row 1 — the first row of the worksheet. When row 1 is hidden, you cannot select a row above it because nothing exists above row 1, making the standard right-click method ineffective. To unhide row 1 specifically, click in the Name Box (the small white box to the left of the formula bar showing the current cell reference), type A1, and press Enter. This selects cell A1 even though it's not visible.

Once A1 is selected (you can confirm by checking that the Name Box shows A1), navigate to the Home ribbon, click Format in the Cells group, hover over Hide & Unhide, and click Unhide Rows. Excel reveals row 1. The same approach works for any row that's hidden at the very top of the visible area — type the cell reference in the Name Box first, then use the Format menu to unhide. This Name Box navigation technique is essential knowledge for anyone who works with Excel files frequently.

The same approach extends to selecting any specific cell or range that's currently outside the visible viewport, including cells in worksheets that scroll horizontally to columns far to the right of the current view. Typing a cell reference into the Name Box is often faster than scrolling for users navigating large workbooks. For example, typing Z500 jumps directly to that cell, regardless of current scroll position.

This skill becomes second nature with practice and significantly speeds up working with large datasets where scrolling would be slow. The Name Box also accepts named ranges, so if you've defined a named range in your workbook, typing the name jumps directly to that range, which is another time-saving technique worth remembering.

One frequent source of confusion involves rows that are hidden by filters versus rows hidden through the right-click Hide command. These two mechanisms work differently and require different approaches to reveal data. Filtered rows display a filter icon on the column header indicating an active filter, and the status bar at the bottom of Excel shows a message about filtered records. Standard Hide-hidden rows display no such indicators — the row numbers simply skip from one value to the next.

To reveal filtered rows, click the Data tab on the ribbon, then click Clear in the Sort & Filter group. This removes all active filters in the worksheet at once, revealing every row that was previously filtered out. Alternatively, click the filter icon on the affected column header and choose Clear Filter From [Column Name] to remove just that column's filter while leaving others intact. To remove filtering entirely (not just clear current filter values), click Data and toggle the Filter button to turn off filtering for the worksheet.

Yet another mechanism that can hide rows is grouping or outlining. Excel allows users to group rows together and collapse them, hiding the data in the collapsed groups. Grouped rows display small minus and plus signs in the left margin or numbers (1, 2, 3) at the top-left indicating outline levels. To expand grouped rows, click the plus signs to expand individual groups, click the higher-numbered outline level (often 2 or 3) to expand all groups simultaneously, or remove grouping entirely via Data → Ungroup → Clear Outline.

Beyond standard hidden rows, Excel supports a special hidden state called Very Hidden, which can only be set or cleared through Visual Basic for Applications (VBA). Rows or worksheets marked Very Hidden don't appear in the standard Unhide dialog and require accessing the VBA editor to reveal. While most Excel users will never encounter Very Hidden content, anyone troubleshooting an inherited workbook with seemingly missing data should be aware of this state's existence.

To check for Very Hidden worksheets specifically, press Alt + F11 to open the VBA editor, find the workbook in the Project Explorer, and look at the Properties window for each sheet. The Visible property shows xlSheetVisible, xlSheetHidden, or xlSheetVeryHidden. Change xlSheetVeryHidden to xlSheetVisible to reveal the worksheet. For very hidden rows specifically, this is rarer and typically indicates programmatic manipulation that may serve a specific purpose — investigate before unhiding to avoid disrupting workbook functionality.

When working with shared workbooks or files received from colleagues, hidden rows sometimes contain calculation cells, working data, or reference information deliberately hidden for cleaner presentation. Before unhiding rows in a workbook you didn't create, consider whether the rows might be hidden intentionally for design reasons. Often it's worth checking with the file's author or examining the contents briefly before deciding whether the data should remain hidden or be revealed permanently for editing.

For users working with very large datasets where hidden rows might exist throughout the workbook, the most efficient unhide approach is to select the entire worksheet and unhide everything at once. Click the small triangle in the top-left corner of the worksheet (where the row and column headers meet) to select all cells. Alternatively, press Ctrl + A twice to select everything (the first Ctrl + A selects the current data region, the second selects the entire worksheet).

With the entire worksheet selected, right-click any row number in the row header column and choose Unhide. Excel reveals every hidden row in one action. Repeat with column headers and Unhide to reveal any hidden columns simultaneously. This method is particularly useful when troubleshooting unfamiliar workbooks where you don't know exactly which rows might be hidden — the bulk unhide approach handles all hidden rows in seconds without requiring you to identify each one.

Excel's row hiding mechanism is fundamentally about row height, not visibility. A hidden row has its height set to 0 pixels. Setting any positive row height value reveals the row. This means you can also unhide rows by selecting adjacent rows, right-clicking and choosing Row Height, then entering a value (commonly 15 for default Excel row height). Excel applies the height to all rows in the selection, including hidden rows, effectively revealing them. This approach is rarely the primary method but provides a useful alternative when the standard Unhide command behaves unexpectedly.

For Excel users who frequently work with hidden rows as part of their workflow, several productivity tips make managing hidden content faster. First, learning both the Hide shortcut (Ctrl + 9) and the Unhide shortcut (Ctrl + Shift + 9) creates a reversible workflow without menu navigation. Second, using Format → Visibility from the Home ribbon provides menu access to all hide and unhide operations from one consistent location. Third, customising the Quick Access Toolbar to include Hide and Unhide commands creates one-click access for repeated operations.

Power users often combine row hiding with worksheet protection to create read-only views of complex spreadsheets. Hidden rows protected with worksheet protection cannot be unhidden by standard means until protection is removed via Review → Unprotect Sheet (which may require a password if one was set). If you encounter a workbook where Unhide is greyed out or unresponsive, worksheet protection is the most likely cause. Check Review → Unprotect Sheet — entering the password (if known) removes protection and enables normal unhide operations.

Excel's row hiding interacts with sorting, filtering, and various other operations in specific ways. Hidden rows are typically included in formula calculations (SUM includes hidden rows by default), but functions like SUBTOTAL and AGGREGATE provide options to exclude hidden rows from calculations. When sorting data, hidden rows are sorted along with visible rows by default, which can create unexpected results if rows were hidden expecting them to remain in place. Understanding these interactions helps avoid surprises when working with workbooks that contain hidden data alongside visible data.

For data analysts and finance professionals who regularly process workbooks from various sources, developing a quick check for hidden content as part of standard workbook intake makes sense. The simple sequence — select all (Ctrl + A twice), right-click row headers, Unhide; right-click column headers, Unhide; Data → Clear filters; Data → Ungroup → Clear Outline — reveals everything potentially hidden in seconds and creates a known starting state for analysis. This pattern is worth memorising and applying as a routine first step on unfamiliar workbooks.