Excel Hide Shortcut: Hide Rows, Columns, and Sheets

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+9 to hide the selected row or rows, and Ctrl+0 to hide the selected column or columns. These shortcuts hide rows and columns, not worksheet tabs; to hide a worksheet, use Alt, H, O, U, S in sequence or choose the Hide Sheet command from the ribbon.

Excel shortcuts for hiding rows and columns

The row and column shortcuts work on the current selection. If a cell is active, Ctrl+9 hides its entire row, while Ctrl+0 hides its entire column. To hide several adjacent rows or columns at once, select them first, then press the relevant shortcut. For example, selecting rows 4 through 7 and pressing Ctrl+9 hides all four rows. The rows still exist; they are simply not displayed.

  • Hide row or rows: Ctrl+9.
  • Hide column or columns: Ctrl+0.
  • Unhide selected hidden rows: Ctrl+Shift+(.
  • Unhide selected hidden columns: Ctrl+Shift+).

The unhide shortcuts work most reliably when the selection includes the hidden area’s neighbors. To reveal row 5, for instance, select rows 4 and 6 (or the surrounding range) and use the unhide command. A hidden row cannot be selected by clicking its missing row number, so selecting the visible rows on either side is important.

Choose the correct selection before hiding

Excel applies the command to whole rows or columns, even if you start by selecting ordinary cells. That can be handy, but it also makes it easy to hide more than intended. If you select cells B3:D5 and press Ctrl+9, Excel hides rows 3, 4, and 5 across the entire worksheet—not just the cells in columns B through D. Ctrl+0 on that same selection hides columns B, C, and D throughout the sheet.

For a precise selection, click a row number or column letter. To select a continuous block, drag across the row numbers or column letters, or click the first one and Shift-click the last. You can also select nonadjacent rows or columns with Ctrl-click on Windows, then apply the hide shortcut. Check the selection shading and highlighted row numbers before pressing the keys, especially in a large worksheet.

One useful workflow is to select the unwanted detail rows by their labels, hide them, and then check the row numbers above and below the gap. If row numbers jump from 12 to 18, rows 13–17 are hidden. This visual cue helps distinguish hidden rows from a worksheet that has simply been scrolled past or filtered.

Hide an entire worksheet

A worksheet tab is different from a row or column. On Windows, use the ribbon sequence Alt, H, O, U, S: press and release Alt, then press H, O, U, and S one at a time. This opens the Home tab’s Format commands and selects Hide Sheet. Alternatively, choose Home > Format > Hide & Unhide > Hide Sheet. You can also right-click the worksheet tab and choose Hide.

To hide a sheet, it must be the active sheet. A workbook must retain at least one visible worksheet, so Excel will not let you hide the only visible sheet. If the workbook has several visible sheets, hiding one removes its tab from view but does not delete its cells, formulas, charts, or other contents. The sheet can be brought back with the Unhide command.

Worksheet visibility can also be restricted by workbook structure protection. If Hide or Unhide is unavailable, check whether the workbook’s structure is protected; a user without the required password or permissions may not be able to change sheet visibility. Sheet protection and workbook-structure protection are separate controls, so a protected worksheet does not automatically mean the workbook’s sheet tabs are protected.

How to unhide rows, columns, and sheets

For rows or columns, select the visible areas on both sides of the hidden range, then use the appropriate unhide shortcut. For example, if rows 8–10 are hidden, select row headers 7 and 11, and press Ctrl+Shift+(. The ribbon alternative is Home > Format > Hide & Unhide > Unhide Rows. For hidden columns, select the column letters on either side and choose Home > Format > Hide & Unhide > Unhide Columns.

If the hidden range is at the top or left edge of the sheet, there may not be a visible neighbor on one side. Select the whole worksheet using the small triangle at the intersection of the row and column headers, then use the ribbon’s Unhide Rows or Unhide Columns command. This can reveal every manually hidden row or column, so be aware that it may expose more than the one range you were looking for.

To restore a hidden worksheet, right-click any visible sheet tab and choose Unhide, select the sheet in the dialog, and confirm. The ribbon route is Home > Format > Hide & Unhide > Unhide Sheet. Excel’s dialog generally lets you choose one hidden worksheet at a time; repeat the process if several sheets need to be restored.

Mac and Excel for the web differences

In Excel for Microsoft 365 on Mac, the common shortcuts are Command+9 to hide rows and Command+0 to hide columns. The corresponding unhide combinations are Command+Shift+9 and Command+Shift+0. Mac keyboard layouts and system settings can affect how these combinations behave, so the ribbon or the row and column context menus are useful alternatives if a shortcut is intercepted.

For a worksheet on Mac, use the sheet-tab context menu or the Format menu’s sheet visibility commands; the Windows Alt-key sequence is not the Mac shortcut. In Excel for the web, use the Home tab’s Format options or the row, column, or sheet-tab context menus. Browser shortcuts can take precedence over some key combinations, and shortcut behavior may vary with the browser and keyboard layout. If a shortcut does nothing in the web app, use the visible menu command instead.

Hide, group, filter, or freeze: which should you use?

Hiding is best when you want rows or columns temporarily out of sight without changing the data. It is a visual change only: formulas can still refer to hidden cells, and hidden values may still appear in calculations. Hiding does not remove records or make information private.

Grouping is often better for detail that readers will need to expand and collapse repeatedly. Select the relevant rows or columns, then use Data > Group. Excel adds outline controls, typically plus and minus buttons, so someone can collapse or expand the grouped detail without manually selecting hidden ranges. Grouping is useful for monthly details under annual totals, or line items beneath a project summary.

Filtering is the right choice when you want to show records that meet criteria, such as orders for one region or dates within a period. A filter dynamically displays matching records and hides nonmatching ones; it is not the same as manually hiding particular rows. Freeze Panes is different again: it keeps selected headings visible while you scroll, rather than hiding anything. Choose based on the task: hide for a temporary layout change, group for expandable detail, filter for criteria-based viewing, and freeze panes for navigation.

Common shortcut problems and fixes

  • Ctrl+0 appears to do nothing: Some Windows configurations or keyboard utilities may intercept this combination. Use Home > Format > Hide & Unhide > Hide Columns instead, or use the column header’s right-click menu.
  • The wrong range disappears: Excel hides complete rows or columns based on the selection, not just the highlighted cells. Press Ctrl+Z immediately to undo the hide, then make a narrower selection.
  • Unhide does not restore anything: Include the row or column headers surrounding the hidden range, not only the visible cells inside the sheet. If you cannot identify the range, select the whole worksheet and use the ribbon command.
  • A sheet cannot be hidden or unhidden: Confirm that more than one sheet is visible and check whether workbook structure protection is enabled. A hidden sheet will not appear in the Unhide dialog if it is set to a special “VeryHidden” state by VBA.
  • The shortcut types a character or triggers another action: Confirm that Excel has focus, check the active keyboard layout, and try the ribbon command. In a browser, a key combination may be handled by the browser rather than Excel.

If you hide a row or column by mistake, Ctrl+Z reverses the action immediately, provided you have not performed another operation that changes the undo history. Hiding and unhiding are ordinary worksheet layout operations; they do not erase cell contents. However, do not assume hidden content is protected from other people who can open the workbook.

Visibility is not data security

Hidden rows, columns, and worksheets remain part of the workbook. A recipient can often reveal them with the same Unhide commands, and formulas, charts, or other workbook features may expose information from hidden cells. Hiding is appropriate for reducing clutter or presenting a cleaner view, not for concealing confidential data. If information should not be shared, remove it from the shared copy or use appropriate access controls rather than relying on visibility settings.

There is a related distinction between hiding a worksheet and protecting it. Worksheet protection can limit editing, while workbook-structure protection can restrict changes such as hiding or unhiding sheets. Neither should be treated as a substitute for securely managing sensitive information. Consider the audience and the data before distributing a workbook, including whether hidden details are still present in formulas, names, charts, or other workbook elements.

Frequently Asked Questions

What is the Excel shortcut to hide a row?
In Excel for Microsoft 365 on Windows, select a cell in the row or select its row header, then press Ctrl+9. For multiple rows, select the rows first.

What is the Excel shortcut to hide a column?
Select a cell in the column or its column header and press Ctrl+0 on Windows. If that shortcut is intercepted, use Home > Format > Hide & Unhide > Hide Columns.

How do I unhide a row in Excel?
Select the row headers above and below the hidden row, then press Ctrl+Shift+( on Windows. You can also choose Home > Format > Hide & Unhide > Unhide Rows.

Is there a shortcut to hide an Excel sheet?
On Windows, press Alt, H, O, U, S in sequence, or use Home > Format > Hide & Unhide > Hide Sheet. The sheet must be active, and at least one other sheet must remain visible.

Does hiding rows remove them from formulas?
No. Hiding changes what is displayed, not the underlying data. Formulas can still use values in hidden rows or columns, so hiding is not a way to delete or secure information.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.