You have tried to unhide rows or columns in Excel, but they remain invisible. The standard methods like selecting adjacent cells and choosing Unhide do not work. This happens when rows or columns are set to a height or width of zero, not just hidden. This article explains the cause and provides the steps to restore these cells to a visible size.
Key Takeaways: Fixing Zero-Size Rows and Columns
- Home > Format > Row Height or Column Width: Manually set a specific size to override a zero value and make the row or column visible.
- Double-click the row or column boundary: Automatically resizes a zero-height row or zero-width column to fit the cell content.
- Select All > Drag a boundary: Select the entire sheet and drag any row or column divider to reset all rows or columns to a standard size.
Why Zero-Size Rows and Columns Are Different From Hidden
Excel has two distinct ways to make rows and columns invisible. The standard Hide command simply sets a row or column property to hidden. Unhiding reverses this property. Setting a row height or column width to zero is a different action. It changes the physical dimension of the row or column to nothing. The Unhide command cannot fix this because the dimension is zero, not hidden.
This often occurs accidentally. Dragging a row divider or column divider all the way to the top or left of the grid sets the size to zero. It can also happen when pasting data from other sources that include these zero-size settings. Visually, a zero-height row makes the row numbers jump, like from row 5 to row 7. A zero-width column makes the column letters skip, like from column C to column E.
Steps to Unhide Zero-Height Rows and Zero-Width Columns
Use these methods to restore rows and columns that have been set to a size of zero. Start with the manual method for precise control.
- Select the rows or columns around the hidden area
Click the row number below and above the missing row. For a missing column, click the column letters to the left and right of the missing column. This highlights the entire range. - Open the Row Height or Column Width dialog
Go to the Home tab on the ribbon. In the Cells group, click Format. From the menu, select Row Height for rows or Column Width for columns. - Enter a new size value
A dialog box will appear. Type a standard value, such as 15 for row height or 8.43 for column width. Click OK. The zero-size row or column will immediately become visible.
Use the Mouse to Autofit or Drag to Resize
If the manual dialog is too slow, you can use the mouse for a quicker fix.
- Position your cursor on the boundary
Move your mouse pointer to the line between the two row numbers or column letters that are adjacent to the hidden area. The cursor will change to a double-headed arrow. - Double-click to autofit
Double-click the boundary. Excel will automatically expand the zero-size row or column to fit any content within it. If the cell is empty, it will set a default size. - Drag to set a custom size
Click and hold the boundary line. Drag it down for a row or to the right for a column. Release the mouse button to set the new, visible size.
Reset All Rows or Columns on the Sheet
If many rows or columns are affected, resetting the entire sheet is efficient.
- Select the entire worksheet
Click the triangle button at the intersection of the row numbers and column letters. This is in the top-left corner of the sheet. It selects every cell. - Reset all row heights
Move your mouse to any line between two row numbers. Click and drag the divider down slightly. This action sets all rows, including zero-height ones, to a uniform, visible height. - Reset all column widths
Move your mouse to any line between two column letters. Click and drag the divider to the right slightly. This sets all columns to a uniform, visible width.
When Standard Methods Do Not Work
Sometimes, zero-size rows or columns are locked or part of a protected sheet. Try these solutions if the basic steps fail.
Excel Does Not Allow Changing Row Height on Protected Sheet
If the worksheet is protected, you cannot modify row height or column width. You must first remove the protection. Go to the Review tab and click Unprotect Sheet. If a password was set, you will need to enter it. After unhiding the rows or columns, you can reapply protection.
Cells Are Part of a Merged or Outlined Group
Rows or columns within a grouped outline or adjacent to merged cells can behave unexpectedly. Clear any outlines via Data > Group > Clear Outline. Unmerge any cells by selecting them and clicking Home > Merge & Center > Unmerge Cells. Then try the unhiding steps again.
File Corruption or Add-in Interference
In rare cases, file corruption or a problematic add-in can prevent resizing. Open the file in Excel’s Safe Mode by holding Ctrl while starting the application. If you can resize rows in Safe Mode, an add-in is likely causing the issue. Disable add-ins via File > Options > Add-ins.
Hidden vs. Zero-Size: Key Differences
| Item | Hidden Rows/Columns | Zero-Height/Width Rows/Columns |
|---|---|---|
| Primary Cause | Right-click > Hide command | Dragging boundary to zero size |
| Standard Fix | Select adjacent cells > Right-click > Unhide | Use Row Height/Column Width dialog or double-click boundary |
| Visual Clue in Sheet | Thicker line between row numbers or column letters | Row numbers or column letters appear to skip |
| Property in Excel | Hidden property is set to TRUE | RowHeight or ColumnWidth property is set to 0 |
| Impact on Selection | Can be included in a range selection | Excluded from mouse selection; must be selected via Go To |
You can now restore any row or column that refuses to unhide. Remember that a zero-size setting requires a different fix than the standard Unhide command. Use the double-click method on a boundary for the fastest repair. For advanced control, use the Go To Special feature by pressing F5, clicking Special, and selecting Visible cells only to work around complex hidden areas.