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.

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

References:

Tiller Money

Tiller Money

Your financial life in a spreadsheet, automatically updated each day.

Start Your Free Trial

Keep a clear, confident view of all your money in one place, with flexible templates, powerful privacy, and top-rated support

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023