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.
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.
- Start by logging into the Google Sheets official website.
- Go into the preferred spreadsheet, hold down the mouse’s left-click button and drag over the cells you’d prefer to hide.
- 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 in between columns B and D. Click on the arrows 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.
Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.
2 thoughts on “How to Hide Cells in Google Sheets”
@Lishani you could set the text colour in the cells you want to hide to match the background colour. Not a perfect solution as anyone could see the data in the cell by clicking on it, but would work for presentation purposes.