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.
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:
- Keyboard shortcuts for Google Sheets
Post navigation
Enter Your Email Below to Try Lido for FREE!
Thanks for Signing Up - Please Check your Email to Verify your Account
Oops! Something went wrong while submitting the form.
100% FREE - No Credit Card Required
Enter Your Email Below to Try Lido for FREE!
Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time!
- One Click Data Imports From Anywhere
- Transform Spreadsheets into Software in Seconds
- Pre-built & Custom Templates
- Visualize Real-Time Data in Centralized Dashboards
Thanks for Signing Up - Please Check your Email to Verify your Account
Oops! Something went wrong while submitting the form.
100% FREE - No Credit Card Required