Google Sheets is an excellent alternative to Microsoft Excel. Some of us even feel it is better. It is much more intuitive. Things are easier to find and do without always having to stop to look things up.
With that said, though, there are some things about Google Sheets that may be a little difficult to figure out at first. This is true of nearly all software, no matter who the manufacturer may be.
When working in Sheets recently, I somehow managed to hide a couple of rows without even realizing I had done so. I still say it was my cat who did it for me while I was outside and my laptop was sitting open on the table. However it happened, I could not figure out how to get them back. Once I did, I decided that others may benefit from what I had found.
Hiding Columns and Rows in Google Sheets
To hide specific rows, right-click on the number of the row all the way to the left and choose ”Hide Row.” If you need to hide multiple rows at the same time, hold your “Shift” key down then click on the bottom (last) row that you want to be hidden. Now, right-click and choose to Hide Rows…..” (The numbers of the rows you selected will be shown in the dialogue.)
The row “disappears” immediately, and Sheets will leave arrow markers behind to remind you there is a row missing.
To hide a column, follow the same process. Right-click the column you do not wish to see, and select ”Hide Column.” Again, if you want to hide multiple columns, hold your “Shift” key down then click on the furthest column to the right that you want to be hidden. Now, right-click and choose to Hide Columns…..” (The numbers of the columns you selected will be shown in the dialogue.)
Again, Google will leave behind markers showing and reminding you that there should be another column there.
The things you have hidden have not disappeared – the information is still there… so let us unhide it now.
Unhiding Rows and Columns in Google Sheets
To unhide a row or column in Sheets, simply click the arrows left behind, as shown in the screenshots above. Magically, the things you had hidden are now restored.
What other questions or conundrums do you have when it comes to working within Sheets?
I hid columns in Sheets by dragging them to the left not by using the arrow and right click “hide columns”
Now I’m having difficulty unhiding them.
parita mehta says
Yes..Thanks a lot for the help.Its quick, simple and easy.
Is there any way to unhide only a single column or range of columns? For example, I have a sheet with columns D-EJ hidden, and I want to see just columns EH, EI, and EJ. Do I have to unhide all 100-something columns in order to see just those three? It’s annoying to then have to re-select that huge range to hide them again.
Adane Markos says
i don’t know without nothing reason my Facebook address is closed please you check and confirm my Facebook code.