To hide rows in Excel for Microsoft 365 on Windows, select them and press Ctrl+9; to hide columns, select them and press Ctrl+0. To hide the active worksheet, press Alt, then H, O, U, S. Hiding conceals content from the normal worksheet view without deleting it, so you can bring it back later. Save your workbook first if the information is important, and remember that hiding is not a security measure.
What You’ll Need
- Excel for Microsoft 365 on a Windows computer. The steps below focus on this version.
- A workbook with the rows, columns, or worksheet you want to hide. If the workbook is read-only or protected, some commands may be unavailable.
- For sheet hiding, at least one other worksheet must remain visible. Excel does not allow you to hide every sheet in a workbook.
Step-by-Step
- Decide what you want to hide. A row is useful for temporarily removing a record or calculation from view; a column is useful for concealing supporting details while leaving the main table visible; a worksheet can be hidden to simplify the sheet tabs. Hiding does not remove the data, change formulas, or prevent someone with access to the workbook from revealing it.
- Select the rows or columns. Click a cell in the row or column you want to hide. To select the whole row containing the active cell, press Shift+Space. To select the whole column, press Ctrl+Space. You can select more than one adjacent row or column by dragging across its numbered row headers or lettered column headers. For nonadjacent selections, hold Ctrl while clicking each header, then use the hide shortcut. If Excel is currently editing a cell, press Esc first so the shortcut acts on the worksheet rather than the text in the cell.
- Hide selected rows. With one or more complete rows selected, press Ctrl+9. Excel hides those rows, and the row numbers jump over the hidden range. For example, if you hide rows 8 through 10, the visible numbering goes from 7 to 11. The cells remain in the workbook, and formulas that refer to them continue to work as before.
- Hide selected columns. Select one or more complete columns and press Ctrl+0. The column letters skip over the hidden columns. For example, if column C is hidden, the visible headers go from B to D. If Ctrl+0 does nothing, see Troubleshooting: some Windows settings or keyboard layouts intercept this shortcut.
- Hide a worksheet using the ribbon key tips. Click the sheet tab you want to hide so it is active. Press and release Alt, then press H, O, U, S in sequence. These are the key tips for Home > Format > Hide & Unhide > Hide Sheet. Do not hold all the keys down together; press each letter after the previous key tip appears. If your Excel build shows different key-tip letters, follow the letters displayed on screen instead.
- Confirm the worksheet is hidden. The selected sheet tab disappears from the tab row. Its data is still in the workbook, and formulas that use the sheet can continue to calculate. If Excel reports that a worksheet must remain visible, another visible sheet is not available; leave at least one sheet unhidden.
- Unhide rows or columns when you need them again. Select the visible row headers on both sides of the hidden rows, then press Ctrl+Shift+9. To reveal a hidden column, select the column headers on both sides and press Ctrl+Shift+0. For example, to reveal hidden column C, select B and D together before using the shortcut. The selection must include the hidden area; selecting only a cell within a hidden row or column is not enough.
- Unhide a worksheet. Press Alt, then H, O, U, H to open the Unhide Sheet command. Choose the worksheet name in the dialog and press Enter. If more than one sheet is hidden, repeat the command for each one. Excel’s standard Unhide command lists ordinary hidden sheets, but does not list worksheets set to “Very Hidden” through VBA.
- Check the result and save. Look for skipped row numbers, column letters, or sheet tabs to confirm what is hidden. Save the workbook after making changes. If you plan to send it to someone, decide whether hiding is genuinely appropriate: hidden data remains part of the file and can be revealed by a recipient who can edit or inspect the workbook.
Mac note: In Excel for Mac, the usual shortcuts are Command+9 to hide selected rows, Command+0 to hide selected columns, Command+Shift+9 to unhide rows, and Command+Shift+0 to unhide columns. Keyboard behavior can vary with macOS settings and keyboard layout. For sheets, use the Excel menu or ribbon commands; the Windows Alt key-tip sequence is not the same on Mac. In Excel for the web, shortcuts can also depend on browser settings, so use the Home ribbon’s Format options if a shortcut is intercepted.
Common Mistakes
- Selecting a cell instead of the entire row or column. Ctrl+9 and Ctrl+0 are intended for whole-row or whole-column selections. If the active cell is all you have selected, first use Shift+Space for its row or Ctrl+Space for its column. Check that the row or column header is highlighted before hiding.
- Trying to reveal a row or column without selecting around it. A hidden header cannot be clicked. Select the visible headers immediately before and after the hidden range, then use the unhide shortcut. If the hidden range is at the top or far left edge, use Go To to select it by reference instead.
- Confusing hiding with deleting. Hidden data remains present and may still feed formulas, charts, or other workbook features. If you truly mean to remove information, make a backup and use a deliberate deletion workflow instead. Conversely, do not delete data just to make a worksheet easier to read if you might need it later.
- Expecting a hidden worksheet to be protected. Hiding a sheet only removes its tab from the normal view. It does not prevent someone from using Unhide, and it does not encrypt or secure the contents. Use appropriate file permissions or encryption when confidentiality matters; do not rely on hidden rows, columns, or sheets to protect sensitive information.
- Hiding the only visible sheet. Excel requires at least one worksheet to stay visible. If the hide command is unavailable or Excel shows a warning, check the other tabs and leave one sheet visible.
- Pressing a key-tip sequence as one chord. Alt, H, O, U, S is a sequence of key presses, not five keys to hold together. Press Alt and release it, then follow each displayed letter. The key-tip sequence may differ if the ribbon is customized or the application version is different.
Tips
- Use Go To for a hidden range at an edge. Press Ctrl+G, enter a reference such as 1:3 to select rows 1 through 3, or A:C to select columns A through C, and press Enter. You can then use the appropriate unhide command. This is particularly helpful when the first row or column is hidden and there is no visible header on one side to select.
- Keep a simple record of hidden areas. Before hiding a group of rows or columns in a shared workbook, add a note in a visible area or document the range elsewhere. A reader may otherwise mistake a skipped row number for missing data. In a complex workbook, a short note such as “Rows 25–30 contain archived items” can save time later.
- Use grouping when people need to expand and collapse sections. Excel’s Data > Group command creates outline controls that users can expand or collapse. This is often clearer than hiding rows manually when a report has optional detail sections. Grouping is a separate feature; it does not change the basic Ctrl+9 shortcut.
- Consider printing and filtering behavior. Hidden rows and columns are generally omitted from a normal worksheet printout, while filters hide matching records temporarily using different controls. If a printout or export must include every record, check the print preview and unhide any ranges that should appear before printing.
- Know what happens to formulas. Hiding a row or column does not ordinarily remove its values from calculations. For example, a SUM across a range still includes hidden cells unless the formula or function is specifically designed to ignore hidden rows. Do not assume that a hidden value has been excluded from a total.
- Use the ribbon if a keyboard shortcut is unavailable. On Windows, the row and column commands are under Home > Format > Hide & Unhide. The same menu includes the commands to reveal hidden rows, columns, and sheets. The ribbon is a practical fallback when system shortcuts conflict with Excel.
Troubleshooting
Ctrl+0 does not hide a column. Some Windows configurations intercept Ctrl+0, including certain regional or keyboard settings. First confirm that an entire column is selected and that Excel is not in cell-edit mode. If the shortcut still fails, use Home > Format > Hide & Unhide > Hide Columns. To reveal it, select the neighboring column headers and use the Unhide Columns command from the same menu.
Ctrl+Shift+9 or Ctrl+Shift+0 does not reveal anything. Make sure you selected the headers around the hidden area, not just a cell elsewhere. If the selection is difficult to make, press Ctrl+G and enter the row or column reference, then open Home > Format > Hide & Unhide and choose the relevant Unhide command. On some systems, the operating system or keyboard layout may capture the shortcut before Excel receives it.
The hidden rows or columns are not consecutive. Reveal each hidden block separately by selecting its visible neighbors. You can also select a larger range that contains the hidden section and use the ribbon’s Unhide Rows or Unhide Columns command. Check that the selected range is not limited to a single visible row or column.
The Unhide Sheet dialog does not show the worksheet. The sheet may already be visible, or it may have been set to “Very Hidden” in the VBA editor. Excel’s ordinary interface does not offer a standard keyboard shortcut to reveal a Very Hidden sheet. If this is your workbook, ask its creator or an authorized workbook administrator to restore it. Do not change workbook code or protection settings unless you understand the consequences.
The sheet-hide command is unavailable. Check that the workbook structure is not protected; workbook-structure protection can prevent users from hiding or unhiding sheets. Also confirm that the active tab is a worksheet and that another sheet will remain visible. If the workbook is shared or restricted by an organization, permissions may limit these changes.
Excel shows different key-tip letters. Key tips can vary between versions, languages, or customized ribbon layouts. Press Alt and read the letters that appear over the ribbon, then follow the path to Format and Hide & Unhide. Alternatively, use the mouse to open Home > Format and select the specific command; this avoids guessing at a sequence.
Frequently Asked Questions
What is the keyboard shortcut to hide a row in Excel?
On Windows, select the entire row and press Ctrl+9. To select the row containing the active cell, press Shift+Space first. On Mac, the usual hide-row shortcut is Command+9.
How do I hide a column using only the keyboard?
Select a cell in the column, press Ctrl+Space to select the entire column, then press Ctrl+0 on Windows. On Mac, the usual shortcut is Command+0. If the shortcut is intercepted, use the Home ribbon’s Format menu.
How do I unhide the first row or column?
Because there is no visible header before the first row or column, select the range through Go To: press Ctrl+G, type 1:1 for the first row or A:A for the first column, and press Enter. Then use Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns. You can also select a broader range that includes the hidden edge and choose Unhide.
Can I hide a worksheet with a single keyboard shortcut?
There is no dedicated Ctrl-key shortcut for hiding a worksheet in Windows Excel. Use the ribbon key-tip sequence Alt, H, O, U, S, or open Home > Format > Hide & Unhide > Hide Sheet. The sequence is pressed one key at a time.
Does hiding a row, column, or sheet remove its data?
No. Hiding changes what is displayed, not the underlying cell contents. Formulas may continue to use hidden values, and someone with access to the workbook can usually unhide the information.
Why does the hidden data still appear in a total?
Many formulas include hidden cells in their calculations. Hiding is a display choice, not a calculation filter. Review the formula and use an appropriate function or criteria if the calculation should exclude certain records; verify the result against the intended data set.
Related
- How to Flip Data in Excel From Bottom to Top Safely
- How to Flip an Excel Page for Printing
- How to Flip an Excel Sheet Upside Down by Reversing Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Checkbox in Word for Forms and ListsTo insert a clickable checkbox in a Word document, turn on the Developer tab, then choose Developer >…
- Excel Solver Shortcut: Open It Faster in Microsoft 365Excel for Microsoft 365 on Windows has no built-in keyboard shortcut dedicated to Solver. The quickest dependable workaround…
- How to Redo in Microsoft Excel: Shortcuts and MenuTo redo an action in Excel for Microsoft 365 on Windows, press Ctrl+Y after you have undone something.…
- Google Sheets Checkbox IF Statements: Examples & TipsIn Google Sheets, use an IF formula to return one result when a checkbox is checked and another…
- How to Make Columns in Word Without Vertical LinesTo make columns in Word without a divider, place the cursor in the text or select the text,…
- Conditional Formatting for Duplicates in ExcelIn Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting > Highlight…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.