How To Unhide Google Sheets Rows

I am using google sheets for a client.

How to unhide google sheets rows. Open your google sheets file as you normally would. 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. You can easily unhide columns in google sheets on your computer or mobile device. Find the arrows in the numbered column to the left above and below the hidden rows and hover your pointer over one of them. You can unhide columns or rows either by clicking or tapping on an arrow or by right clicking on a computer to.

Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet. Tap and hold the highlighted rows. Is there another way that they could be hidden that i can investigate. 5 ways to free up storage space on an iphone. 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.

Drag the handle down to the next visible row. What other questions or conundrums do you have when it comes to working within sheets. If you have any rows hidden in the sheet you should see a menu option that says unhide rows. When the arrow bar appears click one of the arrows and the hidden rows become visible. To unhide all the hidden rows in a flash select all the rows in the sheet and then right click and choose unhide rows.

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. If you cannot find this option it means your worksheet does not have any hidden rows. Tap the row number above the hidden row s. Next right click on your selection.

Whatever the case hiding rows in columns is a helpful trick to have in your google sheets toolbox. Sometimes it is helpful to hide and unhide columns in google sheets. However this is not present on the ones that are already hidden. Unhiding rows and columns in google sheets. Note after selecting the columns or rows you can also perform the above actions hiding unhiding of rows columns using shortcut keys.