How to Unhide Rows and Columns in Google Sheets (Desktop & Mobile)

Published on | ProSheetHub

Hiding rows and columns in Google Sheets is a convenient way to clean up workbooks, stash background calculations, or present clutter-free client summaries. However, when you receive a shared file from a teammate or need to verify raw numbers, missing data can easily cause confusion.

Whether you need to reveal a single hidden row, unhide an entire sheet at once, or uncover that notoriously difficult-to-click Row 1, Google Sheets provides multiple ways to restore hidden data. In this guide, you will learn how to unhide rows and columns on desktop and mobile, keyboard shortcuts, and how to fix missing rows caused by active filters.

1. The Quickest Way: Clicking the Arrow Icons

When rows or columns are hidden manually, Google Sheets displays small opposing triangles (wedge arrows) in the header border where the data was hidden.

Step-by-Step:

  1. Look at the row numbers on the left (or column letters at the top).
  2. Notice the missing sequence (for example, row numbers jumping directly from 4 to 8).
  3. Locate the two small opposing arrows on the border between the visible numbers.
  4. Click the arrows.

The hidden rows (5, 6, and 7) will immediately expand back into view.

2. How to Unhide All Rows or Columns at Once

If a spreadsheet contains multiple hidden sections scattered throughout hundreds of rows, clicking individual arrows one by one takes too long. You can unhide everything in two clicks:

  1. Select the entire worksheet by clicking the empty top-left rectangle located above Row 1 and to the left of Column A (or press Ctrl + A / Cmd + A).
  2. Right-click anywhere on the gray row number headers on the left.
  3. Select Unhide rows from the context menu.
  4. To unhide all hidden columns simultaneously, right-click any column letter header and select Unhide columns.

3. How to Unhide Row 1 or Column A (The Tricky Ones)

When the very first row (Row 1) or first column (Column A) is hidden, finding the arrow can be tricky because it sits flush against the edge of the screen.

Method to Reveal Row 1:

  1. Click and hold your mouse on the Row 2 header.
  2. Drag your mouse slightly upward toward the formula bar so the boundary between Row 1 and Row 2 is highlighted.
  3. Right-click on the Row 2 header.
  4. Click Unhide row 1.
Column A Tip: Use the exact same technique for Column A: right-click the Column B header and select Unhide column A.

4. How to Unhide Rows on the Mobile App (Android & iOS)

On the Google Sheets smartphone and tablet app, the desktop arrow icons can be too small to tap reliably. Use the header selection method instead:

  1. Tap the row header directly above the hidden section.
  2. Drag the selection handle down over the row header directly below the hidden section (for example, select Row 4 through Row 8).
  3. Tap the highlighted row headers to open the contextual popup menu.
  4. Scroll right in the popup menu and tap Unhide.

5. Rows Still Missing? Check for Active Filters

If row numbers jump (e.g., Row 3 goes straight to Row 7) but there are no arrows in the header margin, your rows are not hidden manually—they are being suppressed by a Filter.

Indicator Probable Cause How to Fix
Green header border + funnel icons Active standard filter Click Data > Remove filter from the top menu bar.
Dark gray bar above headers Active "Filter view" Click the X icon in the top-right corner of the dark bar.
Opposing triangles in row numbers Manually hidden rows Click the triangle icon or right-click > Unhide rows.
Row numbers collapsed to 0 height Accidental manual resize Select rows > right-click > Resize rows > Fit to data.

Recommended Next Steps

Restoring hidden structures makes auditing and organizing collaborative sheets straightforward. Continue refining your spreadsheet navigation with these practical tutorials:

Comments

Post a Comment