How To Unhide Google Sheets Rows

Next right click on your selection.

How to unhide google sheets rows. Whatever the case hiding rows in columns is a helpful trick to have in your google sheets toolbox. There are some rows hidden. 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. Open your google sheets file as you normally would. However this is not present on the ones that are already hidden.

If i hide some rows myself then i get a little updown arrow that i can click to unhide them. 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. If you cannot find this option it means your worksheet does not have any hidden rows. Is there another way that they could be hidden that i can investigate.

To unhide a row or column in sheets simply click the arrows left behind as shown in the screenshots above. You can easily unhide columns in google sheets on your computer or mobile device. What other questions or conundrums do you have when it comes to working within sheets. You can unhide columns or rows either by clicking or tapping on an arrow or by right clicking on a computer to. Drag the handle down to the next visible row.

5 ways to free up storage space on an iphone. Tap and hold the highlighted rows. Find the arrows in the numbered column to the left above and below the hidden rows and hover your pointer over one of them. The hidden sheets are a slightly lighter gray color than the visible ones. If you have any rows hidden in the sheet you should see a menu option that says unhide rows.

Tap the row number above the hidden row s. I can not unhide them. Note after selecting the columns or rows you can also perform the above actions hiding unhiding of rows columns using shortcut keys. I am using google sheets for a client. Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet.