How to Hide and Unhide Columns In Google Sheets

Here's how to hide and unhide columns in Google Sheets. This is helpful if you want to only see the most important columns on your spreadsheet.

In order to read and analyze data efficiently on Google Sheets, it’s often helpful to hide some columns to only show the most important columns on your spreadsheet.

This gives you a different perspective of your data, without having the need to delete the information in your spreadsheet.

This will also allow you to quickly perform calculations on a column without scrolling over and clicking the column name every time.

upf

To hide columns on Google Sheets

The basic steps for hiding (and unhiding) columns are easy. Click View > Show Columns, then uncheck any columns that you don’t need, then hit OK.

  • Click on the column header on top of the working area to select the column (or columns), you want to hide.
  • Right-click anywhere on the column
  • Select Hide Column

Alternatively, you can use the following shortcuts to hide columns in Google Sheets, simply select the column, and use the shortcut.

  • For Mac: ⌘ + Option + 0
  • For PC: Ctrl + Alt + 0

To unhide columns on Google Sheets

  • Double-sided arrows on a spreadsheet indicate the presence of hidden columns
  • Simply click on either of these arrows to unhide columns

Alternatively, you can use the following shortcuts to unhide columns in Google Sheets. Simply select the column, and use the shortcut.

  • For Mac: ⌘ + Shift + 0
  • For PC: Ctrl + Shift + 0
upf

References:

Google Workspace Marketplace

Start Your Free Trial

Try Tiller free and track all your accounts in one place, always know where your money goes, and confidently plan your financial future.

Default image
Tiller Money
Your financial life in a spreadsheet, automatically updated each day.