New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Spreadsheet basics›Unhide columns

Google Sheets · Verified tutorial

Unhide columns in Google Sheets

Ensure every column is visible. If any columns are hidden, unhide them. Do not change any values.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Ensure every column is visible. If any columns are hidden, unhide them. Do not change any values.

Step-by-step

1

Select the targetEnsure every column is visible.

2

Apply the changeIf any columns are hidden, unhide them.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

No columns are hidden.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Undo the last change, reselect the intended range, and try again. No columns are hidden.

Example spreadsheet data

This is the clean fixture used for the verified run.

Employee	Department	Week	Hours
Anna	Design	Week 1	32
Ben	Sales	Week 1	38
Cara	Finance	Week 2	35
Dev	Operations	Week 2	40
Eva	Support	Week 3	36

Video transcript

Open the prepared Team schedule spreadsheet.
Select the target. Ensure every column is visible.
Apply the change. If any columns are hidden, unhide them.
No columns are hidden.