How do you unhide columns in Google Sheets
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Steps
-
1
Select columns surrounding the hidden ones.
-
2
Right-click → Unhide columns.
-
3
Or click the arrows in the column header gutter.
Related tutorials
These videos might help you go deeper on this topic.
How To Add Columns in Google Sheets
10 Things I Hate About Your Spreadsheets
2 Ways to Hide Data
Related blog posts
Written guides that go deeper on this question.
How To Hide Data with Checkboxes in Google Sheets
Checkboxes in Google Sheets are a game-changer. They add interactivity, flexibility, and functionality to your spreadsheets, making data management easier and more enjoyable.
Read post →How To Add Columns in Google Sheets
How to add columns in google sheets, in 7 different ways.
Read post →Hide Gridlines
Boost your sheet readability. Hide gridlines for clearer views and discover more tips in our free blog post. Learn and enhance your spreadsheet skills.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Related questions
How to unhide columns in Google Sheets
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Get the answer →Google Sheets how to unhide columns
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Get the answer →How to unhide columns Google Sheets
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Get the answer →How do i unhide columns in Google Sheets
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Get the answer →How to hide and unhide columns in Google Sheets
Select the columns on both sides of the hidden gap, right-click, and choose Unhide columns. Or click the small arrows between column letters. View → Hidden sheets is separate and only applies to whole sheets.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.