How to Hide Cells in Google Sheets

Google Sheets, Google GSuite’s cloud-based version of Microsoft’s Excel, is versatile spreadsheet software that provides a ton of different features for both professional and personal uses.

How to Hide Cells in Google Sheets

Because of Sheets’ versatility, users must know how to manipulate the different aspects of this spreadsheet application to ensure proficiency within Sheets and the GSuite as a whole. One of which includes hiding cells.

What’s interesting about Google Sheets is that you CANNOT hide individual cells when working with the software. While you may think that should be a possibility, it would make the spreadsheet look incredibly strange and would break the workflow as well. That said, there are ways to hide cells, just not individually.

Instead of hiding cells by themselves, you have to hide objects in Google Sheets via the row or column they get placed within. To do so is incredibly simple.

Here’s how to hide cells in Google Sheets, whether you require it to produce a custom spreadsheet or want to hide irrelevant data.

  1. Start by logging into the Google Sheets official website.

  2. Go into the preferred spreadsheet, hold down the mouse’s left-click button and drag over the cells you’d prefer to hide.
  3. Go over to the number on the left of the row or letter at top of the column, right-click it, and select “Hide Column” or “Hide Row,” depending on which one you selected. It’s really that simple.

When following the above steps, it doesn’t delete the row or column. You can unhide the data at any time. You’ll notice that a pair of arrows take the place of the hidden cell numbers or letters. For example, if you choose to hide column C, the arrows will appear on columns B and D. Click on the arrows when the hand icon appears, and the cells will automatically display again.

Congratulations, now you know how to hide rows and columns within Google Sheets! For more helpful tips and tricks, check out our other Google Sheets guides and other GSuite software.

One thought on “How to Hide Cells in Google Sheets”

lishani says:
how do you hide just one or two cells only?
Carter says:
There are ways to hide cells, just not individually. Hiding individual cells would actually make the spreadsheet look incredibly strange and would break the workflow as well.

Leave a Reply

Your email address will not be published. Required fields are marked *


Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.

Todays Highlights
How to See Google Search History
how to download photos from google photos