When someone tells you to "unhide cells" in Excel, they're almost always talking about hidden rows or hidden columns — not individual cells. Excel doesn't actually have a feature to hide single cells in isolation. What it does have is the ability to hide entire rows, entire columns, and entire worksheets. When a row is hidden, every cell in that row disappears from view. When a column is hidden, every cell in that column vanishes. The data is still there; it hasn't been deleted. It simply isn't displaying on screen.
You can tell something is hidden by looking at the row numbers or column letters in Excel's header bar. If you see row numbers jumping from 3 to 7, rows 4, 5, and 6 are hidden. If you see columns jumping from C to G, columns D, E, and F are hidden. The header bar is your first diagnostic tool when something seems to be missing or out of order in a spreadsheet.
Hidden rows and columns are a common spreadsheet management technique. Analysts hide intermediate calculation rows to keep a model clean. Finance teams hide confidential columns when sharing a workbook externally. Dashboards hide raw data tabs to present only the clean output. All of this is legitimate and useful — but it means that understanding how to unhide is an essential Excel skill, whether you're the person who hid the data or you've inherited a spreadsheet from someone else.
There's also a distinction between rows that are hidden and rows that are simply very small. If a row height is set to 1 or 2 pixels, it looks hidden but isn't — the Unhide command won't work on it because Excel doesn't consider it hidden. In that case, you need to resize the row height manually. Keep this in mind as a troubleshooting step if the standard unhide method doesn't seem to be doing anything.
Hidden rows and columns don't affect Excel's calculations — formulas that reference cells in hidden rows still calculate correctly. A SUM formula across a range that includes hidden rows still adds those hidden values. This is an important distinction: hiding is a display-only change, not a data change.
It's also why hidden rows and columns are used so often in financial models and dashboards — you can keep the full calculation intact while presenting only the summary output to the end user. Understanding this display-only nature of hiding also explains why unhiding is always safe; you're just changing what's visible, not adding or removing data. This is a meaningful distinction from deleting — deleted rows are gone permanently (unless you undo immediately), while hidden rows are always recoverable with the Unhide command no matter how long they've been hidden.
Look at the row number column on the left side of your spreadsheet. If you see a gap in the row numbers — for example, the numbers jump from 5 to 9 — rows 6, 7, and 8 are hidden. You'll also notice a slightly thicker line between the last visible row and the next visible row, which is Excel's visual indicator that rows are hidden between those two visible rows.
Click the row number of the last visible row before the gap (row 5 in this example), then hold Shift and click the row number of the first visible row after the gap (row 9). This selects both visible rows and everything between them — including the hidden rows. You must select at least one visible row on each side of the hidden rows for the Unhide command to work correctly.
Right-click anywhere in the selected row header area — on the blue highlighted row numbers on the left side of the spreadsheet. A context menu will appear. Choose 'Unhide' from the menu. The hidden rows will immediately reappear between the rows you selected. If you don't see the Unhide option, you may not have the rows correctly selected — make sure you right-clicked on the row number header, not inside the cells.
With the rows selected, go to the Home tab on the Ribbon, click Format in the Cells group, hover over Hide & Unhide, then click Unhide Rows. This achieves the same result as the right-click method and is useful on tablets or touchscreens where right-clicking is less intuitive. The Format menu is also accessible via keyboard: Alt, H, O, U, R in sequence.
Unhiding columns works by the same logic as unhiding rows, but you work with the column letter headers at the top of the spreadsheet instead of row numbers on the left. The process is nearly identical: select the columns on both sides of the hidden area, then right-click and choose Unhide.
For example, if columns D and E are hidden, you'd click the column C header, hold Shift, then click the column F header to select both visible columns and the hidden ones between them. Right-clicking any part of the selected column headers and choosing Unhide will reveal columns D and E.
Alternatively, after selecting the surrounding columns, go to Home → Format → Hide & Unhide → Unhide Columns. Both methods work identically. If you prefer keyboard navigation, Alt, H, O, U, L (in sequence) triggers the same Unhide Columns command from the Home tab.
One useful technique when you need to unhide all columns in a workbook at once: press Ctrl+A to select the entire spreadsheet, then right-click any column header and choose Unhide. This reveals every hidden column regardless of where they are in the sheet. Use this approach when you've inherited a spreadsheet and aren't sure how many columns are hidden or where they are — selecting everything first means you can't miss any of them.
The same logic applies to unhiding all rows at once: Ctrl+A to select all, right-click any row number header, choose Unhide. This is the fastest way to check whether a spreadsheet has any hidden rows without inspecting every row number sequence manually. After running this on an unfamiliar spreadsheet, scan the row numbers to see if everything is now sequential.
If Unhide does nothing, the row may not be hidden — it may have a row height of 0 or 1 pixel, which makes it invisible without being technically hidden. Select the surrounding rows, go to Home → Format → Row Height, and set a value like 15. This will make the row visible. This situation is common when rows are accidentally resized by dragging the row border instead of being properly hidden.
You can't select the row or column before a hidden Row 1 or Column A because there's nothing there to click. Instead, type A1 in the Name Box (top-left box showing the current cell address), press Enter to navigate to cell A1, then go to Home → Format → Hide & Unhide → Unhide Rows (or Unhide Columns). This navigates to the hidden row or column directly so Excel knows what to unhide.
If the Unhide option is greyed out or missing from the context menu, the sheet may be protected. Go to the Review tab and check for a 'Protect Sheet' button — if it shows 'Unprotect Sheet' instead, the sheet is protected. Click Unprotect Sheet (you may need a password) and then try unhiding again. Protected sheets restrict row and column changes including showing and hiding.
If rows or columns appear to be missing but the row/column numbers are sequential with no gaps, you may be looking at frozen panes rather than hidden rows or columns. Frozen rows and columns stay visible while you scroll, which can cause confusion when the frozen section and the scrollable section don't visually align. Go to View → Freeze Panes → Unfreeze Panes to remove them and restore the normal view.
Worksheets (the tabs at the bottom of the Excel window) can also be hidden independently of rows and columns. A hidden sheet is completely invisible — its tab doesn't appear at the bottom of the screen — but all its data is intact.
To unhide a sheet: right-click on any visible sheet tab at the bottom of the Excel window. Choose 'Unhide...' from the context menu. A dialog box will appear showing a list of all hidden sheets in the workbook. Select the sheet you want to unhide and click OK. Only one sheet can be unhidden at a time through this method — if multiple sheets are hidden, you'll need to repeat the process for each one.
If you want to hide rows, columns, or sheets in a workbook that will be shared with others — and you don't want them to easily unhide the hidden content — protect the sheet or workbook structure before sharing.
Excel has keyboard shortcuts for hiding and unhiding rows and columns, though the unhide shortcut for columns has a notable limitation on Windows. For rows, Ctrl+Shift+9 unhides selected rows and is reliable across Excel versions and operating systems. Select the rows surrounding the hidden area first — including at least one visible row on each side — then press Ctrl+Shift+9.
For columns, the intended shortcut is Ctrl+Shift+0. However, this shortcut is disabled by default in many Windows configurations because it conflicts with the Windows system shortcut for changing keyboard input language. Whether Ctrl+Shift+0 works depends on your Windows language and keyboard settings — many users find it doesn't work on their machine. If it doesn't, use the right-click → Unhide method or the Ribbon approach instead.
The most reliable keyboard approach for columns on Windows is the Alt key sequence: with the columns selected, press Alt, then H, then O, then U, then L in sequence (not simultaneously). This navigates through the Ribbon to Format → Hide & Unhide → Unhide Columns. It's slower than a shortcut but always works regardless of system settings. Practising these Alt sequences for common operations is worthwhile if you do a lot of keyboard-driven Excel work — it can be faster than reaching for the mouse for frequent tasks.
For unhiding all rows or all columns at once, press Ctrl+A first to select the entire spreadsheet, then use the appropriate shortcut or right-click method. This ensures that every hidden row or column in the sheet is included in the selection, so nothing gets missed.
The corresponding hide shortcuts are Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. Knowing both the hide and unhide shortcuts together is useful — if you accidentally hide rows while working with Ctrl+9, you can reverse it immediately by selecting the surrounding rows and pressing Ctrl+Shift+9 without having to navigate any menus. These shortcuts work in Excel for Windows and Mac (with Cmd replacing Ctrl on Mac), making them consistent enough to build into your workflow once you've memorised them.
Excel's grouping feature is a more user-friendly alternative to hiding for rows and columns you need to toggle regularly. Grouping adds a small expand/collapse button (a plus or minus sign) in the margin next to the rows or columns, making it obvious to any user that content can be shown or hidden — and giving them a clear, one-click way to do it without right-clicking or navigating menus.
To group rows, select the rows you want to group, go to the Data tab, and click Group (or press Alt+Shift+Right Arrow). The grouping appears in the margin. Click the minus (-) button to collapse the group and hide those rows. Click the plus (+) button to expand and show them again. Multiple groups can exist at the same hierarchical level, and groups can be nested inside other groups for multi-level outline views.
Grouping is particularly useful in financial models where you might want to hide detailed monthly data while showing quarterly totals, or in project plans where you want to collapse completed phases while keeping future phases visible. The expand/collapse control is self-documenting — anyone opening the spreadsheet can see immediately that there's more detail available beneath the summary view.
To remove grouping without unhiding the rows, select the grouped rows, go to Data → Ungroup (or press Alt+Shift+Left Arrow). The rows remain visible but lose the expand/collapse control. If you want to remove all groups in a sheet at once, go to Data → Ungroup → Clear Outline.
Excel also has an Auto Outline feature (Data → Group → Auto Outline) that automatically groups rows or columns based on summary formulas it detects in the sheet. If your spreadsheet uses SUM or SUBTOTAL formulas to create totals from ranges of detail rows, Auto Outline can detect these relationships and create the grouping structure for you automatically. This is particularly useful for large financial models with consistent formula patterns — it can save significant manual work compared to defining groups row by row.
Groups also work well in combination with conditional formatting — you can format summary rows differently from detail rows to create a clear visual hierarchy that makes sense whether the groups are expanded or collapsed. The combination of grouping for navigation and conditional formatting for visual distinction produces reports that are much more intuitive to navigate than flat spreadsheets with hidden rows.
The steps for unhiding rows and columns on Excel for Mac are essentially the same as on Windows — select the rows or columns surrounding the hidden area, right-click the selection, and choose Unhide. The Ribbon path is identical: Home → Format → Hide & Unhide → Unhide Rows or Unhide Columns.
Keyboard shortcuts differ slightly on Mac. The equivalent of Ctrl+Shift+9 for unhiding rows on Mac is Cmd+Shift+9. For columns, Cmd+Shift+0 is the intended shortcut, but as on Windows, this may conflict with a system shortcut depending on your Mac settings. If Cmd+Shift+0 doesn't work, use the Ribbon method or right-click instead.
One difference between Excel for Mac and Excel for Windows is in the context menu wording — on Mac, right-clicking selected row numbers shows 'Show Rows' rather than 'Unhide' in some versions. These mean exactly the same thing. If you don't see 'Unhide', look for 'Show Rows' or 'Show Columns' instead.
On Excel for Mac, the Name Box method for revealing hidden Row 1 or Column A works the same way: click the Name Box in the top-left corner of the spreadsheet (the box showing the current cell address), type A1, press Return to navigate there, then use the Format menu to unhide. This approach works regardless of which Excel version or operating system you're using, which makes it a reliable fallback when other methods don't apply.
Excel for Mac and Excel for Windows use the same underlying file format (.xlsx), so workbooks with hidden rows or columns display and behave identically across platforms. A workbook with hidden rows created on Windows will show those same rows as hidden when opened on a Mac, and the unhide process on Mac will make them visible in both environments when the file is saved. Platform differences in shortcut keys don't affect the underlying hide/unhide state stored in the file — only the keyboard commands you use to trigger those actions differ between operating systems.
Sometimes data seems to be missing from Excel even though no rows or columns are actually hidden. There are several common causes that are easy to mistake for hidden content.
Filtering is the most frequent culprit. When a filter is active on a column, rows that don't match the filter criteria are hidden from view — but they're not hidden in the traditional sense. The row numbers remain visible but show gaps, which looks exactly like hidden rows.
Look for the blue row numbers and the filter dropdowns in the column headers. To show all rows, go to Data → Clear (to remove the filter entirely) or click the filter dropdown and choose Select All. If blue row numbers appear without apparent filter dropdowns, check whether AutoFilter is enabled under the Data tab.
Scroll position can make data look missing on large spreadsheets. If you're on a sheet with thousands of rows and you've scrolled past the data, the blank area at the bottom looks like missing data. Press Ctrl+End to jump to the last cell with data in the spreadsheet — this shows you the actual extent of the content and confirms whether data is missing or you're just looking in the wrong place.
Merged cells can appear to hide content. When cells are merged across a range and the content is wider than the column, overflow text may be hidden. Unmerging cells (Home → Merge & Center → Unmerge Cells) or widening the column will reveal the full content. Merged cells also affect certain operations like sorting and filtering, so resolving merges that cause confusion is generally a good practice in data tables that require those features.
White text on a white background is a less obvious case where content is technically present but invisible. If a cell looks blank but contains data (you can see content in the formula bar when the cell is selected), the font colour may be set to white. Select the cell, go to Home → Font Color, and change it to Automatic or black. This situation is sometimes used to create hidden-but-present content in dashboards — text that drives formulas or conditional formatting without cluttering the visual layout.