How To Unhide On Google Sheets

You can easily unhide columns in google sheets on your computer or mobile device.

How to unhide on google sheets. Sign into google drive and open the sheets file you wish to modify. Click the view tab at the top of the window. Next right click on your selection. Click the hidden worksheet that you want to unhide. To hide distant rows use the ctrl key instead of the shift key.

Follow the below method screenshot to unhide adjoining rows a single row or distant rows in google sheets. Open your google sheets file as you normally would. Right click and choose hide rows 3 5 to hide the adjoining rows 3 to 5 in google sheets. 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.

Additionally the menu is only hidden on an individual file basis. Click the all sheets button at the bottom left of the window. Method 2 how to unhide a worksheet from the view menu in google sheets. If you cannot find this option it means your worksheet does not have any hidden rows. As with the previous section these steps are performed in the desktop version of the google chrome browser.

Click the downward facing arrow at the top right of the window. When the arrow bar appears click one of the arrows and the hidden rows become visible. If you have any rows hidden in the sheet you should see a menu option that says unhide rows. How to find hidden information in google sheets. To unhide a row or column in sheets simply click the arrows left behind as shown in the screenshots above.

Note that you can also use the ctrl shift f keyboard shortcut to hide and unhide this menu as well. What other questions or conundrums do you have when it comes to working within sheets.