In Excel for Microsoft 365 on Windows, select a cell in the row and press Ctrl+9 to hide that row, or select a cell in the column and press Ctrl+0 to hide that column. Excel does not have a built-in shortcut to hide just one cell while leaving its row and column visible. If you only need to conceal a cell’s displayed value, you can apply a custom number format instead, but that does not protect the value from being seen.
Hiding rows or columns is useful for temporarily getting supporting data, completed work, or less relevant fields out of the way without deleting them. The data remains in the worksheet and can still affect formulas. Before using a shortcut, decide whether you want to hide an entire row or column, or only make a cell look blank.
What You’ll Need
- A workbook open in the desktop version of Excel for Microsoft 365. The Windows shortcuts below are the main instructions; Mac alternatives are noted where they differ.
- The row, column, or cell whose display you want to change. If the workbook is shared, make sure hiding the information will not confuse someone who needs to use the sheet.
- For concealing only a cell’s displayed value, permission to change its number format. This is a visual change, not a security measure.
Step-by-Step
- Choose what you mean by “hide cells.” If you want to remove a full horizontal line of information from view, hide its row. If you want to remove a full vertical field, hide its column. If only one or several cell values should appear blank while other cells in the same row and column remain visible, use the custom-format method in Step 7. Excel’s row and column shortcuts always hide whole rows or columns, not isolated cells.
- Select the row or column. To hide one row, click a cell in that row; to hide several adjacent rows, select cells spanning those rows or click and drag across their row numbers. For a column, click a cell in it or select the relevant column letters. Selecting cells is often quicker than clicking the row or column headers: the shortcut acts on the row or column containing each selected cell. For multiple separated rows or columns, select the nonadjacent ranges with Ctrl held down, then use the shortcut.
- Hide the selected row on Windows. Press Ctrl+9. The selected row or rows disappear, and the row numbers jump over the hidden section. For example, if row 8 is hidden, the visible numbering goes from 7 to 9. The cells have not been deleted; their values and formulas remain in the workbook.
- Hide the selected column on Windows. Press Ctrl+0. The selected column or columns disappear, and the column letters skip the hidden column. If the shortcut does not work, check whether a keyboard utility or system setting is intercepting it, then use the ribbon path in Troubleshooting.
- Use the Mac equivalent when needed. In Excel for Mac, use Command+9 to hide selected rows and Command+0 to hide selected columns. To reveal them again, the usual Mac shortcuts are Command+Shift+9 for rows and Command+Shift+0 for columns. Shortcut behavior can depend on the keyboard layout and macOS settings, so the ribbon commands are a dependable alternative.
- Unhide a row or column when you need it again. Select the visible row headers immediately above and below the hidden row, then press Ctrl+Shift+9 on Windows. For a hidden column, select the visible column letters on both sides and press Ctrl+Shift+0. On a Mac, use the corresponding Command+Shift shortcuts above. If the hidden section is at the top or left edge, or you cannot select the boundary headers, select the whole worksheet using the small triangle at the intersection of the row numbers and column letters, then use the unhide shortcut. This reveals all hidden rows or columns of that type on the sheet.
- Use the ribbon if shortcuts are inconvenient. Select the relevant row or column, then go to Home > Format > Hide & Unhide > Hide Rows or Hide Columns. To bring them back, select the adjacent headers and choose Unhide Rows or Unhide Columns from the same menu. In Excel for the web, keyboard shortcuts may be handled differently by the browser; the ribbon commands are a useful fallback.
- Make one cell display as blank, if that is what you need. Select the cell or range, press Ctrl+1 on Windows to open Format Cells, choose the Number tab, select Custom, enter three semicolons (
;;;) in the Type box, and choose OK. The selected values will no longer display in the grid. To undo this, open Format Cells again and choose an appropriate number format, such as General. On Mac, use Command+1 to open Format Cells. This only changes how values are displayed; the formula bar, copying, and workbook data can still expose them.
Common Mistakes
Expecting a shortcut to hide just one cell. Ctrl+9 and Ctrl+0 work at the row and column level. If you press Ctrl+9 with a single cell selected, Excel hides the entire row containing it, which may make other data disappear too. For a cell-only visual effect, apply the custom format described above, or consider whether a separate presentation sheet would be clearer.
Confusing hiding with deleting. Hidden content stays in the file. Formulas can continue to use hidden values, and sorting, filtering, printing, or sharing the workbook may produce results that surprise someone who does not know rows are hidden. If data should no longer be present, hiding is not a substitute for removing it.
Trying to unhide from the cell grid alone. The blank-looking area may not provide an obvious place to click. Select the row numbers or column letters on either side of the gap, not just nearby cells, before using the unhide shortcut. If you cannot identify the range, select the entire sheet and unhide all rows or columns.
Assuming a hidden value is private. A custom format does not remove a value from the workbook. Users may see it in the formula bar, reveal it by changing the format, or access it through other workbook features. Hidden rows and columns are similarly easy to reveal. Do not use either method to secure confidential information.
Forgetting that another feature may be responsible. A row absent because of a filter, a collapsed outline, or a grouped section may not respond as expected to the ordinary unhide command. Check the filter controls and outline symbols as well as the row and column headers.
Tips
- Use the shortcut that matches the direction. Think “9 for rows, 0 for columns” on Windows. Select cells first if that is faster than targeting a narrow row or column header, and remember that Excel applies the command to the full row or column.
- Keep track of hidden sections. Add a note on a nearby visible cell, or use a consistent convention for temporarily hidden helper rows. This can help you or a colleague understand why row numbers or column letters are missing later.
- Reveal everything before handing off an unfamiliar workbook. If you are unsure what has been hidden, use the select-all triangle and unhide rows and columns. Review the sheet afterward, since this may also reveal items intentionally kept out of view.
- Use grouping for sections you will collapse repeatedly. Select the rows or columns, then use Data > Group to create an outline that can be expanded or collapsed with its plus and minus controls. Grouping is easier to manage for recurring report sections, though it is not a privacy feature.
- Consider filters for lists. If the aim is to show only records matching a condition, use Excel’s filter controls rather than manually hiding rows. A filter makes the reason for omitted records clearer and can be changed without having to unhide individual rows.
- Check the printed or shared result. Hidden rows and columns are usually omitted from the visible worksheet view and printout, but workbook settings and the recipient’s actions matter. Preview the printout or inspect a copy before distributing an important report.
Troubleshooting
The shortcut does nothing. First click a cell in the row or column you want to hide and try again. If you are using Windows, confirm that you are pressing the number-row key for 9 or 0, rather than relying on an unexpected key combination from a specialized keyboard. On some systems, Ctrl+0 may be intercepted or disabled by a setting or utility. Use Home > Format > Hide & Unhide to perform the action from the ribbon instead.
The wrong information disappeared. Press Ctrl+Z on Windows, or Command+Z on Mac, to undo the last action if it is still available. Then select the correct row or column and repeat the appropriate shortcut. If you selected a cell range spanning several rows, remember that all intersecting rows may have been hidden.
I cannot tell which rows or columns are hidden. Look for a jump in row numbers or column letters, or for a narrow double line between headers. Select the headers on both sides of the gap and use the relevant unhide command. If the hidden rows are at the top or hidden columns are at the far left, select the worksheet using the top-left triangle and unhide all rows or columns. This is broader than unhiding a single section, so check the sheet before continuing.
The unhide shortcut does not reveal the data. Make sure you selected the row or column headers around the gap. Then check whether a filter is active: open the filter drop-down and clear the criteria, or use Data > Sort & Filter > Clear where available. If outline symbols show that a group is collapsed, click its plus sign or expand the outline. A row hidden by a filter or collapsed group may need that feature reversed instead of the standard unhide command.
The custom format hides the value but I need it back. Select the affected cell, press Ctrl+1 on Windows or Command+1 on Mac, and choose a suitable format on the Number tab, such as General. If you do not know which cells were changed, select the relevant range and apply General, knowing this can alter how dates, percentages, or other values appear. For that reason, restore only the intended cells when possible.
Frequently Asked Questions
What is the Excel shortcut to hide cells?
There is no separate shortcut for an individual cell. On Windows, Ctrl+9 hides the selected row and Ctrl+0 hides the selected column. On Mac, use Command+9 and Command+0.
How do I hide several rows or columns at once?
Select the row or column headers for the full range, or select cells that span the rows or columns, then use the relevant hide shortcut. For separated ranges, Ctrl-click the headers on Windows to add nonadjacent selections before using the command.
How do I unhide rows or columns in Excel?
Select the visible headers on both sides of the hidden section and press Ctrl+Shift+9 for rows or Ctrl+Shift+0 for columns on Windows. On Mac, use Command+Shift+9 or Command+Shift+0. If you cannot select the hidden section’s boundaries, select the full worksheet and unhide all rows or columns.
Can I hide a cell’s value without hiding its row?
Yes, you can make the cell appear blank by applying the custom number format ;;; through Format Cells > Number > Custom. This does not secure the value: it may remain visible in the formula bar or through formatting and copying.
Will formulas still use hidden cells?
Yes. Hiding a row or column changes what is displayed, not the underlying data. Formulas that refer to hidden cells can still calculate with those values. A filtered list can behave differently in some calculations, so check the formula and the result if your report depends on filtered records.
Can I use these shortcuts in Excel for the web?
Shortcut behavior can vary because the browser may use some key combinations for its own commands. If a shortcut does not work, select the row or column and use Home > Format > Hide & Unhide. The workbook’s rows and columns remain available to reveal later.
Related
- Fill Color in Excel Using Keyboard Shortcuts on Windows
- How to Flip Data in Excel From Bottom to Top Safely
- How to Flip an Excel Page for Printing
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Format by Number Range with Conditional FormattingTo format Excel cells by number range, select the cells and choose Home > Conditional Formatting > Highlight…
- Excel Merge Cells in Each Row Without Losing ValuesTo merge cells horizontally in every row of a selected range in Excel for Microsoft 365 on Windows,…
- Excel Day Based on Date: Find the WeekdayTo show the weekday for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a…
- Add Chapter Page Numbers in Word: A Step-by-Step GuideTo add chapter page numbers in Word, format your chapter titles with the numbered Heading 1 style, then…
- Select an Entire Row in Excel With Shift+SpaceTo select an entire row in Excel, click any cell in that row and press Shift+Space on Windows.…
- Excel Paste Text Without Text to Columns?Yes. To paste tab- or line-break-separated text into a single Excel cell without splitting it across columns or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.