How to Unhide Rows and Columns in Google Sheets
Google Sheets is helpful about hidden rows — it puts small arrow icons in the row header where rows are hidden. Click the arrows and hidden rows reappear. This guide covers all three cases: hidden rows, columns, and sheets.
⚡ Quick Answer
Look for the small ◄► arrow icons in the row/column header where rows are hidden. Click them to unhide. Alternatively, select rows/columns on either side, right-click, and choose Unhide rows.
Method 1: Click the arrow indicators
Sheets marks hidden rows/columns with arrow icons in the header — much friendlier than Excel's "guess where they are" approach.
Look for the arrow icons
Where rows are hidden, you'll see two small arrows pointing toward each other in the row number column. Same for columns — arrows appear in the column letter header.
Click the arrows
Hidden rows or columns unhide.
Method 2: Right-click unhide
Select rows on both sides
If rows 5-7 are hidden, click row 4 and drag to row 8 to select rows 4-8.
Right-click and choose Unhide rows
Right-click any selected row number. Menu appears. Click Unhide rows.
Method 3: Unhide all rows at once
Select entire sheet
Click the small blank rectangle at the top-left where row numbers and column letters meet. Or press Ctrl + A twice.
Right-click a row number
Click Unhide rows. All hidden rows in the sheet unhide simultaneously.
Method 4: Unhide a hidden sheet
Click View → Show → Hidden sheets
Submenu appears listing all hidden sheets in the workbook.
Click a hidden sheet to unhide it
The sheet appears in the tab bar. Repeat for other hidden sheets.
Right-click any visible sheet tab at the bottom. If any sheets are hidden, you'll see "View hidden sheets" in the menu. Same result as View → Show → Hidden sheets.
Why unhide isn't working
- Rows are filtered, not hidden. A filter can hide rows without them being "hidden" per se. Data → Remove filter reveals all rows.
- Filter view is active. Filter views hide rows for just your view of the sheet. Top-right corner shows a filter view name — click X to close it.
- Sheet is protected. A collaborator locked structural changes. Check Data → Protect sheets and ranges.
- Row height is 0, not hidden. Right-click the row number → Resize row → set to 21 (default). Or drag the row border down.
Filter view vs hidden rows
These often get confused:
| State | How to spot it | How to fix |
|---|---|---|
| Hidden rows | Arrow icons in row number column | Click arrows, or right-click Unhide |
| Filter active | Filter arrows in column headers, top toolbar shows filter icon | Data → Remove filter |
| Filter view active | Sheet border turns dark gray, filter view name in top-right | Click X in top-right to close |
| Row height 0 | No arrows, no filters, just missing rows | Right-click row → Resize row |
Keyboard shortcuts
Hide & Unhide Shortcuts
Sheets Wizard — clean sheets without hiding
People hide rows and columns as a workaround for "I don't want to see these right now." Sheets Wizard's AI can restructure your data so important content stays visible and details are progressively disclosed. Ask "hide the intermediate calculations and show me just the summary" and Wizard builds a proper summary view.
Install Sheets Wizard →Frequently asked questions
How do I unhide rows in Google Sheets?
Look for the small arrow icons in the row header where rows are hidden — two arrows pointing toward each other. Click the arrows to unhide. Alternatively, select the rows on either side of the hidden ones, right-click, and choose Unhide rows.
How do I unhide a hidden sheet in Google Sheets?
Click View → Show → Hidden sheets. A submenu lists all hidden sheets. Click the one you want to unhide. Or right-click any sheet tab and hover 'View hidden sheets'. Both approaches show the hidden sheets list.
Why can't I unhide rows in Google Sheets?
Common reasons: (1) A filter is active hiding rows — Data → Remove filter. (2) A filter view is active — top-right corner, click X to close. (3) The sheet is protected preventing structural changes. (4) The rows aren't actually hidden — they have height 0. Right-click a row header → Resize row → set to 21 (default).
How do I unhide all rows at once in Google Sheets?
Click the top-left rectangle where row and column headers meet to select the entire sheet (or press Ctrl+A twice). Right-click any row number and choose Unhide rows. All hidden rows in the sheet become visible.