How To Unhide Google Sheets Rows

Open your google sheets file as you normally would.

How to unhide google sheets rows. To unhide a row or column in sheets simply click the arrows left behind as shown in the screenshots above. Tap the row number above the hidden row s. Find the arrows in the numbered column to the left above and below the hidden rows and hover your pointer over one of them. 5 ways to free up storage space on an iphone. Unhiding rows and columns in google sheets.

The hidden sheets are a slightly lighter gray color than the visible ones. If you cannot find this option it means your worksheet does not have any hidden rows. Tap and hold the highlighted rows. You can easily unhide columns in google sheets on your computer or mobile device. You can unhide columns or rows either by clicking or tapping on an arrow or by right clicking on a computer to.

I can not unhide them. To unhide all the hidden rows in a flash select all the rows in the sheet and then right click and choose unhide rows. Sometimes it is helpful to hide and unhide columns in google sheets. Magically the things you had hidden are now restored. You can also unhide a sheet by clicking the view tab at the top of the window selecting the hidden sheets option then clicking on the sheet that you wish to unhide.

Note after selecting the columns or rows you can also perform the above actions hiding unhiding of rows columns using shortcut keys. Drag the handle down to the next visible row. What other questions or conundrums do you have when it comes to working within sheets. Whatever the case hiding rows in columns is a helpful trick to have in your google sheets toolbox. You may have some completed tasks that you want to indicate as completed to your users or you may want to hide columns that you have used for working.

Next right click on your selection. If i hide some rows myself then i get a little updown arrow that i can click to unhide them. Is there another way that they could be hidden that i can investigate. If you have any rows hidden in the sheet you should see a menu option that says unhide rows. Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet.