iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
This Itechguide teaches you how to hide columns in Google Sheets. The guide offers steps for Google Sheets App for Android and from a PC.
Option 1: Hide Columns via the Android App
If you use Google Sheets App on your Android device, here are the steps to hide columns:
- Open Google Sheets App on your device.
- Then open the sheet you want to edit. On the Google Sheets App, recent documents will be listed beneath Last opened by me. However, you can open a document from Google Drive. To open a document from Google Drive, click the folder icon on top of the App (highlighted in the image below).
- Once you open the Google Sheets document, click and hold the column you want to hide. When you click and hold the column a set of options will be displayed. On the options menu, click on the 3 dots.
- Then scroll down the list that is displayed and click Hide column. When you hide a column, two back to back arrows will display at the point the column is hidden (see the second image below). To unhide the column click one of the arrows.
Option 2: Hide Columns Using a PC
If you use a PC to access Google Sheets here are the steps to hide columns in Google Sheets:
Free tools Windows power users keep installed
One-click scans. No signup required.
- Open Google Sheets from a browser on your PC. Then open the Google Sheets document you want to edit. You could also access your Google Sheets from Google Drive.
- There are two methods to hide a column – 1. right-click the column you want to hide and select Hide column.
- 2. hover over the column you want to hide. Then, click on the drop-down (highlighted in the first image below) and select Hide column.
- The column will be hidden! In my example, notice that column D is no longer in my document. One way to tell that a column is hidden is the existence of 2 back to back arrows – see the highlighted portion of the image below.
- To unhide the column, click on one of the back to back arrows. Your column will reappear!
There could be so many reasons you may want to hide a column in a spreadsheet – you no longer want the column or the data in it.
Popular on Amazon
No matter your reason for wanting to hide that column I hope you found this guide useful. I hope you found this Itechguide helpful.
If you were able to hide columns in Google Sheets with the steps in this guide, click on “Yes” beside the “Was this page helpful” question below.
Also popular on Amazon
You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteFor more Google guides, visit our Google How To page.
Quick Recap
Also popular on Amazon
Also popular on Amazon
Also popular on Amazon
- hole punched
- high quality card stock
- 4 pages
- made in USA
- keyboard shortcuts
