How To Hide Cells In Google Sheets

In this tutorial, you will learn how to hide cells in Google Sheets

How To Hide Cells In Google Sheets

The option to hide cells in Google Sheets can be a great way to keep your spreadsheets looking neat and organized. It can also be helpful when you want to keep certain information hidden, such as internal formulas and calculations.

In this guide, we will show you how to quickly and easily hide cells in Google Sheets. We will also explain how to unhide cells in case you decide you need to view them again.

We will also explain how to hide an entire sheet which can be useful if you have several sheets you cannot delete but want to archive instead.

How To Hide Columns and Rows In Google Sheets

Here’s how to hide columns and rows in Google Sheets.

Step 1

First, select the range you want to hide. You can choose to hide rows or columns depending on your needs.

In this example, we want to hide the email_address and phone_number field from the employee directory spreadsheet.

Step 2

Right-click on the selection and click on the Hide columns… option.

You may also use shortcut keys to hide your selection. Windows users will need to type the CTRL+ ALT+ 0 shortcut. For macOS, use the shortcut COMMAND+ OPTION+ 0.

Step 3

The selected rows or columns should now be hidden from view. Google Sheets will display two outward facing arrows in the row or column header to indicate where the hidden values are located.

Step 4

You might want to unhide the row or columns later on. To do this, select the columns or rows surrounding the hidden area.

Step 5

Right-click on this selection and select the Unhide columns option.

Step 6

The hidden values should now appear in its original place.

Step 7

We can perform a similar procedure to hide rows. Click on the row headers on the left to select a single row or a range of rows.

Step 8

Right click on the selection and click the Hide rows… option.

The selected rows should now be hidden from view.

Step 9

You can also choose to hide an entire sheet as well. Right-click on the sheet tab and select the Hide sheet option.

Step 10

Hidden sheets will not show up as a tab but are still accessible from the All Sheets icon.

Summary

This guide should be everything you need to hide cells in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.