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