How to Unhide Rows and Columns in Google Sheets (2026 Guide)
Home›Google Sheets›Unhide Rows
Google SheetsHow-To⏱ 1 min read

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.

  1. 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.

  2. Click the arrows

    Hidden rows or columns unhide.

Method 2: Right-click unhide

  1. Select rows on both sides

    If rows 5-7 are hidden, click row 4 and drag to row 8 to select rows 4-8.

  2. Right-click and choose Unhide rows

    Right-click any selected row number. Menu appears. Click Unhide rows.

Method 3: Unhide all rows at once

  1. Select entire sheet

    Click the small blank rectangle at the top-left where row numbers and column letters meet. Or press Ctrl + A twice.

  2. Right-click a row number

    Click Unhide rows. All hidden rows in the sheet unhide simultaneously.

Method 4: Unhide a hidden sheet

  1. Click View → Show → Hidden sheets

    Submenu appears listing all hidden sheets in the workbook.

  2. Click a hidden sheet to unhide it

    The sheet appears in the tab bar. Repeat for other hidden sheets.

Alternative: right-click any sheet tab

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:

StateHow to spot itHow to fix
Hidden rowsArrow icons in row number columnClick arrows, or right-click Unhide
Filter activeFilter arrows in column headers, top toolbar shows filter iconData → Remove filter
Filter view activeSheet border turns dark gray, filter view name in top-rightClick X in top-right to close
Row height 0No arrows, no filters, just missing rowsRight-click row → Resize row

Keyboard shortcuts

Hide & Unhide Shortcuts

Hide selected rowsCtrl + Alt + 9
Unhide selected rowsCtrl + Shift + 9
Hide selected columnsCtrl + Alt + 0
Unhide selected columnsCtrl + Shift + 0
Skip the Hiding

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.