How to Unhide Columns in Google Sheets

Unhide one or more columns in Google Sheets using the hidden-column arrows or the adjacent-column right-click method.

Direct answer

Quick answer

For one hidden range, select the columns on both sides of the gap, right-click, and choose Unhide columns, or click the small hidden-column arrows. To reveal every hidden column, select the entire sheet, right-click a column header, and choose Unhide columns.

Fastest method

Click the hidden-column arrows

The arrows appear where the missing column letter used to be.

Multiple hidden columns

Select adjacent columns → right-click → Unhide columns

Select a visible column on each side of the hidden range.

All hidden columns

Select all → right-click a column header → Unhide columns

Reveals hidden columns across the entire sheet.

Describe the How To Unhide Columns In Google Sheets you need in plain English

Press ⌘+Enter to submit

February column restored

After selecting columns B and D and choosing Unhide columns, column C reappears between January and March.

After selecting columns B and D and choosing Unhide columns, column C reappears between January and March.
A · Product	B · January	C · February	D · March
Starter	$8,200	$8,900	$9,400
Pro	$12,600	$13,100	$14,000

Step-by-step instructions

Find the hidden column
Look for a skipped column letter or the small arrows that mark a hidden column.
Select the columns on both sides
Drag across the visible column letters immediately before and after the hidden range, such as B and D.
Unhide the columns
Right-click the selected column letters and choose Unhide columns.
Use the arrow shortcut
For one hidden column, click either small arrow where the missing column letter used to be.
Reveal all hidden columns
To unhide all columns across the sheet, click the select-all box above row 1 and left of column A, right-click any visible column header, and choose Unhide columns.

Common mistakes to avoid

Ctrl+Shift+9 is not the Google Sheets command for unhiding columns; use the arrows or the right-click method.
Select column letters, not individual cells, before opening the right-click menu.
A filtered-out column is different from a hidden column; check Data > Remove filter if no column letters are missing.

Official references: Google: Hide and show rows or columns