You may not always need all the columns that have the data or extra columns that are empty and need not be displayed.
In such cases, you can easily hide columns in Google Sheets.
And there are many ways to do.
In this tutorial, I will show you multiple ways of hiding columns in Google Sheets (basic + advanced)
Shortcut to Hide Column in Google Sheets
If you are a keyboard person like me and prefer using a lot of shortcuts (instead of switching between the mouse and keyboard), this one is for you.
To hide a column (or a range of columns), select the column(s) and use the below shortcut:
CONTROL + ALT + 0 (hold the Contorl and ALT keys and then press 0)
When you use this shortcut, all the selected rows would be hidden
Hide Columns with Right-Click
Another quick method to hide columns in Google Sheets is by using a simple right-click method.
Below are the steps to hide a column in Google Sheets:
- Select the entire column (or columns) you want to hide. To do this, click on the column header at the top of the working area
- Right-click anywhere in the column
- Click on ‘Hide Column’
The above steps would hide the selected column.
The above steps also work for a range of columns and even non-contiguous columns.
For example, if you want to hide column D and G, hold the shift key on the keyboard and select both these columns using the mouse. Once selected, right-click on any of the columns and click on ‘Hide Columns’
Hide Unused columns in Google Sheets
If you don’t want unused rows and columns to be visible in the Google Sheets worksheet, you can easily hide these.
Below are the steps to hide unused columns in Google Sheets:
- Select the first column next to the last used column. You need to select the entire column by clicking on the column header at the top.
- Hold the CONTROL and SHIFT keys and press the right-arrow key. This will select all the unused columns.
- Right-click on any of the selected columns and click on the Hide Columns E-Z option (in your case, it may show different column alphabets based on what columns you have selected.
In Step 3, you can also use the keyboard shortcut CONTROL + ALT + 0 to hide all the selected columns.
You can also use the same methodology to hide unused rows as well.
Hide Columns In Google Sheets App
If you use Google Sheets app on Android on iOS, you can easily hide columns there as well.
Below are the steps that will hide the columns in a Google Sheets app in an Android device (same for iOS as well):
- Open the Google Sheets document and select the worksheet in which you want to hide the column
- Tap the column header to select the entire column. In this example, I tapped on Column E
- Touch the Column header E and hold it for a second. It will make available a menu of options as shown below. Click on the three dots at the right of the menu
- Tap on the Hide Column option and it will hide column E in the Google Sheets App
Unhide Columns In Google Sheets
When you hide a column or range of columns, you can easily unhide these using a single click.
Below is an example where I have hidden Column B and you will notice small double-pointed arrows in between columns A and C. This is a visual indication that there is a hidden column(s) in between the two columns.
To unhide a column, simply click on this icon and it will show all the columns that hidden in between the two columns.
You may also like the following Google Sheets article: