How to Hide Cells in Google Sheets

Who I am
Bernard Perron
@bernardperron
Author and references

Google Sheets, the cloud-based version of Microsoft's Google GSuite Excel, is a versatile spreadsheet that provides a ton of different features for business and personal uses.

Due to the versatility of Sheets, users should know how to manipulate different aspects of this spreadsheet application to ensure mastery of Sheets and GSuite as a whole. One of them includes cell masking.

What's cool about Google Sheets is that you CANNOT hide individual cells while working with the software. Although you might think this should be a possibility, it would make the spreadsheet look incredibly weird and also disrupt the workflow. That said, there are ways to hide cells, but not individually.



Instead of hiding cells by themselves, you need to hide objects in Google Sheets by the row or column they are placed in. To do this is incredibly simple.

Here's how to hide cells in Google Sheets, whether you need them to produce a custom spreadsheet or want to hide irrelevant data.

  1. Start by logging into the Official Google Sheets Site.
  2. Go to the preferred worksheet, hold down the left mouse button and drag over the cells you prefer to hide.
  3. Go to number to the left of the row ou letter at the top of the column, right-click it and select "Hide column" ou ā€œHide lineā€, depending on which one you selected. It really is that simple.

When you follow the above steps, the row or column is not deleted. You can view the data at any time. You will notice that a pair of arrows takes the place of hidden cell numbers or letters. For example, if you choose to hide column C, the arrows will appear between columns B and D. Click the arrows and the cells will reappear automatically.



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

Audio Video How to Hide Cells in Google Sheets
add a comment of How to Hide Cells in Google Sheets
Comment sent successfully! We will review it in the next few hours.