How To Hide Cells In Google Sheets
I’ve mentioned on here before that Google Sheets, Google GSuite’s cloud-based version of Microsoft’s Excel is a versatile spreadsheet software that provides a ton of different features for both professional and personal use cases.
Because of its versatility, it’s important that users know how to manipulate the different aspects of this spreadsheet so they can ensure proficiency within not only Sheets but within the GSuite as a whole.
If they’re looking to master the GSuite, it’s likely that a user will have all sorts of questions appear while working within the software. Some questions are complex monstrosities, like how to interact between the multiple pieces of software and ensure compatibility. Others are incredibly simple, such as moving rows or organizing files within the GSuite.
In this post, we’re going to show you not only how to hide cells in Google Sheets, but we’ll also detail a whole host of different ways to streamline your workflow within the Google Sheets software.
How To Hide Cells In Google Sheets
What’s interesting about Google Sheets is that you actually can’t hide individual cells when working with the software. While you may think that should be a possibility, it would actually make the spreadsheet look incredibly strange and would break the workflow as well. That said, there are ways to hide cells, just not individually. If you’d like to do so, follow these steps.
Instead of hiding cells by themselves, you have to hide objects in Google Sheets via the row or column they are placed within. To do so is actually incredibly simple.
Start by logging into Google Sheets via its official website. From here, go into the preferred spreadsheet, hold down left-click and drag over the cells you’d prefer to hide. Then, go over to the number on the left of the row or top of the column, right-click it, and select the hide option. It’s really that simple.
However, if you’d like to recover these hidden cells, you have to follow an additional step. You’ll notice that a pair of arrows will take the place of the hidden cell numbers. They’ll be attached to the outer barriers of the cells you’ve chosen to hide. For example, if you choose to hide B4 through H7, the arrows will appear on A4 to I7. If you click on the arrows, however, the cells will automatically reappear.
Anyways, now that you know how to hide columns and rows within Google Sheets, there are a few other Sheets tips to show you to increase your proficiency. I’ve written about these before and will showcase them again here.
How To Manipulate Rows and Columns in Google Sheets
Within the Google Sheets spreadsheet, make sure you select the rows and columns you’d like to manipulate. You can do so by taking your left-mouse button, clicking it down, and holding it while dragging it across the desired cells.
From here, you’re going to select the Edit tab on the top left of the spreadsheet. Then, there are an array of different options for you to pick that allow you to manipulate the selected rows and columns.
Per the selected options, here are a few highlights:
Moving A Row Or Column
Depending on if you’ve picked a row or a column, you can move the information up/down and left/right, respectively. Simply select the cells, go to the Edit tab on the top left, and choose the move option within the list.
You can also merge cells within Google Sheets. To do so, simply select an array of cells you’d like to merge, head up to the “Format” tab on the top left of the screen, maneuver to “Merge Cells,” and select between “Merge All,” “Merge Horizontally,” or “Merge Vertically.” You can also do the same with rows and columns by following similar steps.
Change Row Height
As more of a quality of life touch, you can also manipulate the row height within a Google Sheets spreadsheet. This can be done manually or by entering different inputs.
To do so manually, simply hover your mouse under or on top of the row you want to edit. Click and drag either up or down and adjust to your heart’s content. Otherwise, if you’re going to do so manually, just right-click on the number of the row you want to modify. From here, go down the drop-down list into “Resize Row.” A pop-up box will appear, and you can enter your desired row height in pixels. Click okay once done, and you’re set!
Congratulations, now you know how to hide rows and columns within Google Sheets! Don’t forget to check out our other guides on Google Sheets and other software within the GSuite all over TechJunkie.