In Excel for Microsoft 365 on Windows, select the row or rows and press Ctrl+9 to hide them; select columns and press Ctrl+0 to hide them. To hide a worksheet, use Home > Format > Hide & Unhide > Hide Sheet. The right command depends on what you want out of sight: a row, a column, or an entire worksheet.
Which Excel hide command should you use?
“Hide” is not one universal Excel command. Rows and columns are hidden within a worksheet, while hiding a sheet removes its tab from view. The underlying cell contents remain in the workbook in all three cases; hiding changes what is displayed, not whether the information exists.
- Hide rows: Select their row numbers, then press Ctrl+9.
- Hide columns: Select their column letters, then press Ctrl+0.
- Hide a worksheet: Select its tab, then choose Home > Format > Hide & Unhide > Hide Sheet.
For example, if a budget worksheet has detailed calculations in rows 20 through 35 that you do not need to see while reviewing the summary, select row headers 20 through 35 and hide those rows. If the details belong on a separate worksheet, hide that sheet instead. Choosing the appropriate level makes the workbook easier to navigate and helps avoid hiding material that someone still needs to see.
How to hide and unhide rows
To hide a row, click its numbered header at the left edge of the worksheet. To select several adjacent rows, drag across their row headers or select the first header and Shift-click the last. Then press Ctrl+9, or use Home > Format > Hide & Unhide > Hide Rows. The row numbers jump across the hidden range: for example, after hiding rows 5 through 7, the visible headers go from 4 to 8.
To bring rows back, select the row headers immediately above and below the hidden range and press Ctrl+Shift+9. The ribbon alternative is Home > Format > Hide & Unhide > Unhide Rows. If rows 5 through 7 are hidden, select headers 4 and 8 together, then choose Unhide Rows. You can select across a gap by dragging over the visible headers on either side or by selecting the surrounding range.
When the first row is hidden, there is no visible row header above it to click. One option is to select a range that includes row 1 using the Name Box, the field to the left of the formula bar, and then use the ribbon’s Unhide Rows command. For example, enter 1:2 in the Name Box and press Enter, then choose Home > Format > Hide & Unhide > Unhide Rows. The same idea applies when the first column is hidden: select a range that includes column A before using Unhide Columns.
How to hide and unhide columns
Click a column letter to select a column. Drag across the letters to select adjacent columns, or select a first column and Shift-click the last. Press Ctrl+0 to hide the selection, or choose Home > Format > Hide & Unhide > Hide Columns. For example, hiding columns D through F makes the visible headings move directly from C to G.
To unhide columns, select the column letters on both sides of the hidden range and press Ctrl+Shift+0, or choose Home > Format > Hide & Unhide > Unhide Columns. If column D is hidden, select columns C and E together and use Unhide Columns. Some Windows keyboard or language settings intercept Ctrl+Shift+0, so the ribbon command is a dependable alternative if that shortcut does nothing.
You can also change a column’s width to zero through formatting, which has much the same visible result as hiding it. However, use the Hide Columns command when you want a clear, reversible hide action. If a column seems to have disappeared, it may simply be extremely narrow rather than hidden; selecting the columns around it and choosing Unhide Columns or adjusting the width can help diagnose the difference.
How to hide or show a worksheet
To hide a worksheet, click its sheet tab, then choose Home > Format > Hide & Unhide > Hide Sheet. You can also right-click the tab and choose Hide. The worksheet tab disappears, but the sheet and its contents remain in the workbook. Formulas on other sheets can still refer to cells on a hidden sheet.
To restore a hidden worksheet, choose Home > Format > Hide & Unhide > Unhide Sheet, select the sheet name in the dialog, and click OK. Right-clicking a visible sheet tab and choosing Unhide opens the same type of dialog. In standard Excel, the dialog lets you unhide one sheet at a time; repeat the action if several sheets are hidden. Excel requires at least one worksheet to remain visible, so it will not let you hide the workbook’s last visible sheet.
Windows does not provide a single default Ctrl-based shortcut equivalent to Ctrl+9 for hiding a sheet. You can use the ribbon key sequence Alt, H, O, U, S to open Hide Sheet, and Alt, H, O, U, H to open Unhide Sheet. Press the keys in sequence rather than all at once. Ribbon key tips can vary with interface versions or customization, so use the visible ribbon path if a sequence does not work.
Windows, Mac, and Excel for the web
The shortcuts above are for Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the usual row and column shortcuts use Command instead of Ctrl: Command+9 hides selected rows, Command+Shift+9 unhides rows, Command+0 hides selected columns, and Command+Shift+0 unhides columns. Mac keyboard settings can affect shortcut availability, so use the menus if a shortcut is intercepted.
On Mac, the ribbon’s Home tab includes the Format options for hiding and unhiding rows, columns, and sheets; right-clicking a sheet tab also provides Hide and Unhide. In Excel for the web, use the ribbon commands when a desktop shortcut is unavailable or intercepted by the browser. The web version may handle keyboard combinations differently depending on browser and operating system. If you cannot find a command, check that you are on the Home tab and open Format in the Cells group.
What hiding changes—and what it does not
Hidden rows and columns are removed from the normal worksheet view, and hidden sheets are removed from the tab bar. Hiding does not delete values, formulas, formatting, or worksheet content. Calculations can continue to use hidden cells, and other workbook users may be able to reveal the information with an Unhide command. A hidden worksheet is therefore not a private or secure place to store sensitive information.
Hiding also differs from filtering. A filter displays only rows that match selected conditions and can change which records are visible as those conditions change. Hiding rows manually is a fixed display change until someone unhides them. Similarly, grouping rows or columns adds outline controls that let readers expand and collapse a section; ordinary hiding does not add those controls. For a report with optional detail, grouping may be clearer than simply hiding a block.
Hidden rows and columns are generally omitted from the visible worksheet printout, which can affect the layout of a report. Hidden sheets are not printed merely because they exist; they must be made visible to print their contents in the usual way. Always use Print Preview to check the result, especially if page breaks, print areas, or repeated heading rows are involved. Hiding is a display choice, not a reliable way to control what other people can access or what a workbook contains.
Common problems and practical fixes
- The shortcut does nothing: Check that the worksheet is active and that you selected row or column headers, not just cells. For columns, try the ribbon if Windows intercepts Ctrl+Shift+0 or the keyboard layout changes the shortcut.
- Unhide does not reveal anything: Make sure your selection includes the hidden range’s boundaries. If the hidden row or column is the first one, select a range containing row 1 or column A through the Name Box, then use the ribbon command.
- The Hide or Unhide option is unavailable: The workbook’s structure may be protected. Check Review > Protect Workbook; if structure protection is enabled, an authorized person may need to remove it before changing sheet visibility.
- A worksheet is missing from Unhide: It may not be hidden in the ordinary way, or you may be looking at a different workbook. Excel’s standard Unhide dialog lists worksheets hidden through the usual Hide command, not sheets hidden by every possible advanced or programmatic setting.
- Some data is still visible: Hiding one row or column does not hide related copies elsewhere, such as a summary, chart, or another worksheet. Check the workbook’s other views before sharing it.
Choosing between hide, filter, and group
Use hiding when you want to temporarily remove a known row, column, or worksheet from view without deleting it. It works well for supporting calculations, infrequently needed fields, and completed sections of a working report. Keep in mind that another person may not realize hidden content exists, so label the workbook or leave a note if the concealed section is important to its use.
Use a filter when readers need to choose which records to display, such as showing only one department in a staff list. Use grouping when readers should be able to expand or collapse related detail with outline buttons. If information should not be shared, remove it from the copy you distribute or use an appropriate access-control approach; hiding alone does not protect it. For a workbook shared with colleagues, documenting how to restore hidden sections can prevent confusion later.
Frequently Asked Questions
What is the shortcut to hide rows in Excel?
On Windows, select the row headers and press Ctrl+9. To show the rows again, select the headers around the hidden range and press Ctrl+Shift+9.
What is the shortcut to hide columns in Excel?
Select the column letters and press Ctrl+0 on Windows. To unhide them, select the columns on either side and press Ctrl+Shift+0. If that combination is intercepted by your system, use Home > Format > Hide & Unhide.
How do I hide a sheet in Excel?
Click the sheet tab and choose Home > Format > Hide & Unhide > Hide Sheet, or right-click the tab and choose Hide. The sheet remains in the workbook and can be restored with Unhide Sheet.
Why can’t I unhide a row or column?
You may not have selected the hidden range’s surrounding headers, or the row or column may have been reduced to a very small width or height. Select a range spanning the affected area and use the ribbon’s Unhide command; for the first row or column, include it through the Name Box.
Does hiding a sheet protect its information?
No. Hiding removes the sheet tab from the ordinary view but does not encrypt or secure the contents. Someone with access to the workbook may be able to unhide the sheet, so do not rely on hiding to protect confidential data.
Related
- Link Excel to Excel: How to Connect Workbooks and Cells
- Redo in Excel: Shortcuts, Limits, and Fixes
- How to Link Excel to Another Sheet in Microsoft 365
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Randomize Numbers in Excel Without DuplicatesTo randomize the numbers 1 through 20 without duplicates in Excel for Microsoft 365, enter this formula in…
- Unhide Columns in Excel: Keyboard Shortcuts and StepsTo unhide columns in Excel for Microsoft 365 on Windows, select the column headers on both sides of…
- Excel Data Analysis Regression Tool: How to Use ItExcel’s regression tool is the Regression option in the Analysis ToolPak. In Microsoft Excel for Microsoft 365 on…
- Google Sheets 2D Data Validation: How to Set It UpGoogle Sheets does not have a special “2D data validation” rule that reads a grid and automatically chooses…
- Google Finance Codes for Sheets: Tickers and ExamplesIn Google Sheets, “Google Finance codes” usually means the ticker symbol and, when needed, its exchange prefix used…
- MS Excel Solver: How It Works, Setup, and When to Use ItMicrosoft Excel Solver is an optimization add-in that finds values for selected cells to maximize, minimize, or reach…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.