Can you hide data in Google Sheets?

Do you want to hide rows/columns?  I do this when publishing or sharing a sheet for people to view and I don't want them to see email addresses or other confidential information.

To hide a column:  

1. Click on the arrow at the top of a column.
2. Choose Hide Column.
3. The column is now hidden from view.
4. To get it back, click on the arrows that surround the hidden column.

To hide a row:

1. Right Click on the row number.
2. Choose Hide Row.
3. The row is now hidden from view.
4. To get it back, click on the arrows that surround the hidden row.

Warning:  If you share this document with someone using &newcopy, they will be able to see the columns and rows you have hidden.

How to Hide Rows in Google Sheets

There are a few ways to hide rows in Google Sheets. One way is to use the hide function. To hide a row, select the row you want to hide and then click on the "hide" button in the toolbar. Another way to hide a row is to use the filter function. To hide a row using the filter function, select the row you want to hide and then click on the filter button in the toolbar. A third way to hide a row is to use the conditional formatting function. To hide a row using the conditional formatting function, select the row you want to hide and then click on the conditional formatting button in the toolbar.

You may not always need all the columns that have unsightly data or extra columns that are empty. In such cases, you can easily hide columns in Google Sheets.

And there are many ways to do.

In this Google spreadsheet hide columns tutorial, I will show you all the ways you can hide columns.

• The Google Sheets Hide Columns Shortcut
• How to Hide Columns in Google Sheets With a Right-Click
• Hide Unused Columns In Google Sheets
• Hiding Columns in Google Sheets With the Help Menu
• Unhide Columns In Google Sheets
• How to Hide Rows in Google Sheets
• How to Collapse Columns in Google Sheets Mobile
• Frequently Asked Questions
  • How Do You Hide Columns in Google Sheets?
  • How Do You Hide Rows in Google Sheets
  • How Do I Hide Columns in Google Sheets for Certain Users?
  • How Do I Remove Infinite Columns in Google Sheets?
  • Can Viewers See Hidden Columns in Google Sheets?

The Google Sheets Hide Columns Shortcut

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 in Windows (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)

For macOS, use the following shortcut instead:

Command + Option + 0

When you use this shortcut, all the selected rows or columns will be hidden.

Note: You don’t even need to select the entire column to use this shortcut to hide it. Even if a cell in a column is selected, this shortcut will hide that column. For example, if you have selected cell A5 and you use this shortcut, it will hide the entire column A.

How to Hide Columns in Google Sheets With a Right-Click

Another quick method to hide columns in Google Sheets is using a simple right-click method. You simply have to select the columns, right-click them, and select Hide column(s).

Below are the steps to hide a column in Google Sheets:

1. 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
2. Right-click anywhere in the column
3. Click on ‘Hide Column’
   

The above steps would hide the selected column.

The above steps also work for a range of columns, grouped rows and columns, and even non-contiguous columns.

For example, if you want to hide columns 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:

1. 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.
2. Hold the CONTROL and SHIFT keys and press the right-arrow key. This will select all the unused columns.
3. 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.

Hiding Columns in Google Sheets With the Help Menu

You can also hide columns with the help menu. All you have to do is:

1. Highlight the columns you wish to hide in the headers
2. Navigate to Help in the Sheet menu
3. Type “hide” and press Enter

Unhide Columns In Google Sheets

After 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 between columns A and C. This visually indicates that there is a Google Sheets hidden column(s) between the two columns.

To unhide a column, simply click one of the arrow icons, and it will show all the columns that are hidden in between the two columns.

You can also use keyboard shortcuts to unhide columns in Google Sheets.

To unhide a column in Windows (or a range of columns), select the column(s) and use the below shortcut:

CONTROL + Shift + 0 (hold the Contorl and ALT keys and then press 0)

For macOS, use the following shortcut instead:

Command + Shift + 0

When you use this shortcut, all the selected rows or columns will be unhidden.

Related Reading: How to Hide Gridlines in Google Sheets

How to Hide Rows in Google Sheets

You can apply everything in this article to hide rows in Google Sheets or unhide rows too. For example, to use the right-click method, all you have to do is select the row, right-click them, then select Hide row(s). Here’s a full breakdown of how to hide a row in Google Sheets:

1. Highlight the rows you want to hide in the row headers
2. Right-click in the highlighted rows
3. Left-click on Hide rows
   
   
   
   

If you want to hide more than one row, make sure you hold Ctrl when you left-click.

How to Collapse Columns in Google Sheets Mobile

If you use the 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 on an Android device (same for iOS as well):

1. Open the Google Sheets document and select the worksheet in which you want to hide the column
2. Tap the column header to select the entire column. In this example, I tapped on Column E
   
3. 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
   
4. Tap on the Hide Column option and it will hide column E in the Google Sheets App
   

Frequently Asked Questions

These FAQs should help you get a full grasp of how to hide cells in Google Sheets.

How Do You Hide Columns in Google Sheets?

Select the column header(s), right-click, and select hide columns.

How Do You Hide Rows in Google Sheets

Hiding rows in Google Sheets is simple, just select the row header(s), right-click, and select hide columns.

How Do I Hide Columns in Google Sheets for Certain Users?

You just have to protect the range before you collapse the column. Then the users will be able to see that certain columns are hidden but won’t be able to unhide them. We have a full tutorial on how to hide columns in Google Sheets for certain users.

How Do I Remove Infinite Columns in Google Sheets?

You can simply delete excess rows and columns. Here’s how to hide unused cells in Google Sheets:

1. Select the column you would like to delete from
2. Press Ctrl+Shift+Right Arrow (Command instead of Ctrl for Macs) This will highlight all the columns to the right
3. Right-click, and select Delete, you can also hide the columns instead, by clicking Hide columns

You can repeat this to collapse rows in Google Sheets by using the Up Arrow or Down Arrow instead. This is how to hide all the unused cells in Google Sheets.

Can Viewers See Hidden Columns in Google Sheets?

No, only those with Edit or Owner access may view or change hidden rows.

Now that you’ve learned how to hide columns in Google Sheets, you may also like the following articles:

• How to Hide Zero Values in Google Sheets
• How to Filter By Color in Google Sheets
• How to Delete Empty Rows in Google Sheets
• How to Unhide Rows in Google Sheets
• How to Insert Multiple Columns in Google Sheets

Can you hide values in Google Sheets?

How to hide formula in Google sheet without protecting sheet?