Excel: How to Hide Rows and Columns

To hide rows or columns in Excel, select the row or column headers, right-click, and choose Hide. To show them again, select the headers on both sides of the hidden area, right-click, and choose Unhide.

Hide Rows or Columns with the Ribbon

You can also use Excel’s ribbon if you prefer not to use the context menu. First select the row numbers or column letters you want to hide. Then open Home, choose Format in the Cells group, point to Hide & Unhide, and select Hide Rows or Hide Columns. The command applies to the entire selected rows or columns, not just the cells currently visible in the worksheet.

1. To hide a row, click its number at the left edge of the sheet. Drag across several row numbers to select a range.
2. To hide a column, click its letter at the top. Drag across adjacent letters to select multiple columns.
3. Choose the relevant Hide command from the right-click menu or the Home ribbon.

For example, selecting row headers 5 through 8 and choosing Hide conceals all four rows. The visible row numbers jump from 4 to 9. The cells are still in the worksheet; Excel has only hidden their display.

Selecting Several or Nonadjacent Areas

For a continuous group, select the first header and drag to the last. You can also click the first header, hold Shift, and click the last header to select the range. Then hide it in one operation.

To select separate rows or columns, hold Ctrl while clicking the individual headers in Excel for Windows. On a Mac, use Command for nonadjacent selections. Once selected, use Hide. Keyboard selection details can vary by platform and keyboard settings, so the ribbon or right-click menu is a reliable alternative.

To select a large range by its reference, use the Name Box to the left of the formula bar. Enter a reference such as 5:8 to select rows 5 through 8, or C:F to select columns C through F, then press Enter and hide the selection. This is useful when the desired headers are far apart on screen.

Unhide Rows and Columns

To unhide a section between visible headers, select the headers on both sides of it. For hidden rows 5 through 8, select rows 4 and 9 together, right-click either selected header, and choose Unhide. For hidden columns C through F, select columns B and G and choose Unhide. You can select a range that includes visible and hidden headers; the command reveals the hidden portion.

If the hidden section is at the very top or far left, there may be no visible header on one side. Select the whole worksheet using the small triangle above row 1 and left of column A, then use Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns. This reveals all hidden rows or columns on the sheet, so it may also reveal areas you intended to keep hidden.

Another option is to enter a known cell or range in the Name Box, such as A1:A8, then use the ribbon’s Unhide Rows command. The Name Box can help select an area that is difficult to reach with the pointer.

Keyboard Shortcuts and Other Ways to Hide

Excel provides keyboard shortcuts, though the exact key sequence depends on the operating system and keyboard. In many Windows desktop versions, select the rows and press Ctrl+9 to hide them; use Ctrl+Shift+9 to unhide rows. For columns, use Ctrl+0 to hide and Ctrl+Shift+0 to unhide. Some Windows configurations reserve or block the column shortcuts, so use the ribbon if they do not work.

On Mac, shortcut combinations differ across Excel releases and keyboard layouts. Check the Hide & Unhide menu in your version rather than assuming a Windows shortcut applies. Excel for the web may also differ in shortcut support; its ribbon and context menus provide a straightforward route.

You can hide a row or column by changing its size to zero: select the headers, open Home > Format, and choose Row Height or Column Width, then enter 0 where supported. The Hide command is generally easier to reverse and makes your intent clearer.

What Hiding Does—and Does Not Do

Hiding is a display choice, not a way to delete or secure data. Hidden cells remain part of the workbook, and formulas can continue to refer to them. For example, a total using SUM can include values in a hidden row. Hiding a row does not automatically remove its value from calculations.

Likewise, hiding columns is not a privacy control. Anyone with access to the workbook may be able to unhide them or inspect the data in other ways. If information must be restricted, do not rely on hiding rows or columns; use appropriate access controls and share only the data intended for the recipient.

There is a related distinction between hiding and filtering. Hiding manually conceals selected full rows or columns until you unhide them. A filter shows or hides rows according to criteria, such as displaying only orders marked “Open.” Filters are better for changing which records appear as the data changes; manual hiding is useful for temporarily simplifying a worksheet.

Common Problems and Quick Checks

• Unhide is unavailable or seems ineffective: Make sure your selection includes the hidden area’s neighboring headers. If unsure, select the entire sheet and use Unhide Rows or Unhide Columns.
• A row or column still seems missing: Check whether its height or width was set to zero or an unusually small value. Select it through the Name Box and set a normal height or width with the Format menu.
• Row numbers or column letters jump: A jump, such as 12 to 16, usually indicates hidden rows. It can also result from a filter, so check whether filtering is active before assuming the rows were manually hidden.
• Shortcut keys do nothing: Use the ribbon command. Keyboard shortcuts may differ by Excel platform, and some may be intercepted by operating-system settings.
• You cannot change the sheet: Worksheet protection or workbook restrictions may prevent formatting changes. If you are authorized to edit the file, check the Review tab for protection controls or ask the workbook owner for access.

Frequently Asked Questions

How do I hide a column in Excel?
Select its letter at the top of the worksheet, right-click, and choose Hide. To hide several adjacent columns, select all their letters first.

How do I hide a row in Excel?
Click the row number, right-click, and choose Hide. You can select multiple row numbers to hide a range at once.

How do I unhide the first row?
Select the whole worksheet using the triangle at the upper-left corner, then choose Home > Format > Hide & Unhide > Unhide Rows.

Do formulas include hidden rows?
Often, yes. Hiding a row does not delete its values, and functions such as SUM can still include them. Some functions, such as SUBTOTAL, can treat filtered or manually hidden rows differently depending on the function number used.

Can I hide rows based on their values?
Use a filter when you want Excel to show or hide records according to criteria. Manual Hide is a fixed display change and does not automatically respond when cell values change.