How to Hide Columns in Google Sheets (and Get Them Back)

Some columns are working notes. Others hold numbers you need for a formula but don't want a client to stare at. Hiding a column in Google Sheets tidies the view without deleting a thing, which is why it's one of the first tricks worth learning.

I've followed Google's help pages for the steps, and I'll be straight about one point: hiding is for neatness, not secrecy. More on that below.

Hiding a column in Google Sheets on your computer

1. Open your spreadsheet in Google Sheets on your computer.
2. Click the column letter to highlight the column.
3. To hide several columns, hold the command key and click each one. Google's help mentions the command key, which is the Mac key, so use your own keyboard's equivalent if you're not on a Mac.
4. Right-click and choose Hide column.

An arrow appears where the column used to be, so you can see that something is tucked away.

Unhiding columns in Google Sheets

Click the arrow where the column letter used to be. Google's help describes it just like that. The hidden column comes back with its data intact, because nothing was ever removed.

Hiding columns in the Sheets app on Android

1. Open the spreadsheet in the Google Sheets app on your Android device.
2. Touch and hold a row or column.
3. In the menu that appears, tap Hide column.

Google's help page doesn't list unhide steps for Android, so if you need a column back, the quickest reliable route is to unhide it in a computer browser.

Hiding columns in the Sheets app on iPhone and iPad

1. Open the spreadsheet in the Google Sheets app.
2. Tap the column you want to hide.
3. In the menu, use the right arrow and choose Hide column.

Hiding a column versus hiding a whole sheet tab

They're different features. Google's help on protecting and hiding sheets says hiding a sheet is not the same as protecting it, and that editors can still unhide a hidden sheet. The same logic applies to hidden columns: anyone who can edit can bring them back by clicking the arrow.

Why hiding columns in Google Sheets isn't a privacy tool

This matters if you share a Sheet with clients or contractors. Google says protection shouldn't be used as a security measure, because anyone with access can still print, copy, paste, or import and export copies. A hidden column is no stronger. If the data in it's private, such as personal details or internal notes, don't share that file at all. Make a separate copy without those columns.

When hiding columns helps a small business

• Sharing a customer list: hide the notes column before you screen-share on a call.
• Planning sheets: tuck helper columns away so the finished view looks calm.
• Reports for a client: hide the working columns and leave only the ones they need.
• Wide trackers: hide columns you rarely use so the important ones fit on screen.

When a Sheet is going to a client, I'd also look at my notes on filling in a Google Docs template correctly, because the same care over presentation applies. If you'd prefer to enter data through a form instead, see my comparison of Google Forms alternatives.

A tidy way to share a Google Sheet with hidden columns

If you want to share a clean view without risking anything, a short checklist helps. None of this comes from a single Google page, it's just the routine I'd follow myself:

1. Duplicate the tab so your full working version stays untouched.
2. On the copy, delete or move out anything private rather than only hiding it.
3. Hide only the helper columns that are harmless but distracting.
4. Open the copy in a fresh browser window to see what a viewer would see.
5. Share the copy, and keep the original somewhere only you can reach.

Hiding is still great for readability. The mistake is treating it as a lock. A neat Sheet with a few columns tucked away looks professional, and the arrows at the gaps tell anyone who's curious that more is available if they have the right access.

One last habit: give every column a clear heading before you hide any of them. When a Sheet has been passed between a few people, a gap with an arrow and no obvious heading nearby is how data gets forgotten. A short note in the first row, or a line in the sharing message saying which columns are tucked away, saves someone a confused afternoon.

If you can't hide a column in Google Sheets

1. Check you have edit access, not view-only.
2. Make sure you clicked the column letter so the whole column is highlighted.
3. On a phone, touch and hold (Android) or tap (iPhone and iPad) the column to bring up the menu.
4. If you can't find the arrow to unhide, look at the edges of the columns either side of the gap.
5. Reload the page and try again.

Hiding columns in Google Sheets, device by device

Where you work	How Google's help says to hide a column
Computer	Highlight the column, right-click, choose Hide column
Android	Touch and hold, then tap Hide column
iPhone and iPad	Tap the column, use the menu arrow, choose Hide column
Bring it back (computer)	Click the arrow where the column used to be

Frequently asked questions

How do I hide columns in Google Sheets?

On a computer, click the column letter, right-click and choose Hide column. An arrow appears where the column was. On phones, use the row and column menu in the app.

How do I unhide a column in Google Sheets?

On a computer, click the arrow where the column letter used to be.

Can I hide several columns at once?

Yes. Google's help says to hold the command key and click each column, then right-click and choose Hide column.

Does hiding a column delete the data?

No. The data stays in the sheet and returns when you click the arrow.

Can people still see hidden columns?

Anyone who can edit can unhide them, and Google says protection isn't a security measure. Don't share private data in a hidden column.