This wikiHow teaches you how to show hidden rows in Google Sheets. Hiding rows and columns in Google Sheets is quite easy. While displaying rows and columns is fairly easy, the option to do so is quite difficult to find. Follow the guide below to show hidden rows in Google Sheets.
Step
Step 1. Open Google Sheets
Visit https://sheets.google.com using a browser. If you're already signed in to your Google account, visiting the Google Sheets site will display all the documents linked to your account.
Sign in to your Google account if you're not already signed in automatically
Step 2. Open the Google Sheet document that contains the hidden rows
If there are rows that are not visible, there are arrows above and below the hidden rows. The arrows are in the number column on the left. In addition, the line number is also not visible.
If there are no hidden rows, you can hide them by right-clicking the row number in the far left of the column, then clicking "Hide row"
Step 3. Click above or below the hidden row
Click the small triangle above or below the hidden row to display it.
