How to Unhide Rows in Google Sheets

- Written by Puneet

excelchamps-free-courses-puneet-gogia

Let’s say you manage a project tracker in Google Sheets, and some rows with old tasks are hidden to keep it tidy. A team member asks for information on a task from last month, and you need to unhide these rows to find the details.

In this tutorial, we will use all the available methods to unhide the rows (Single + Multiple) in Google Sheets.

Find the Hidden Rows in the Google Sheets

Hidden rows can be found using the below steps:

  • Open to the data set wherein you want to review for the hidden rows.
  • Scroll the data set to examine the row headers and if you notice any gap or missing number between the row’s header numbers sequence, it means there are rows hidden between them.
data-with-hidden-rows
  • The other way for large data sets, instead of scrolling is to first select the entire sheet by just clicking on the top left corner of the spreadsheet.
  • After that, place the mouse courser on that white blank cell and right click the mouse button to get the drop-down list opened.
  • The drop-down list will show the “Unhide rows” option only if there would be any row(s) hidden in the data set.
choose-unhide-rows

Unhide Rows with the Double Arrow Option

This option is good enough only if you have a small data set otherwise scrolling down again and again to find the missing number sequence could be time consuming.

  • First, Identify the hidden rows by finding the missing rows number sequence or double arrow icons on the row headers.
  • Click on the double arrow icon of the row header above the missing row(s).
identify-hidden-rows
  • The very next moment, the rows hidden between that specific double arrow icon will get unhidden.
unhide-rows-using-double-arrow

Unhide only Specific Hidden Rows Using the Right Click

  • First, identify which hidden rows you want to unhide.
  • After that, click on the row header number of the row just above the hidden rows and that row will get selected.
  • Now, press and hold the shift key and scroll down to select the multiple rows between which only you want to unhide the hidden rows.
  • Once selected, right click, and then click on “Unhide rows” option from the drop-down menu.
unhide-rows-using-right-click

Unhide All Hidden Rows Using the Right Click

  • Select the first row of your data set.
unhide-all-the-hidden-rows
  • After that, press and hold the ctrl and shift keys together and then press the downward arrow key to select the entire data set.
  • Once selected, do right click, and then click on “Unhide rows” from the menu to make all the hidden rows visible in one go.
choose-hidden-rows-option

Unhide Rows Using the Keyboard Shortcut

For those who love to use shortcuts, Google sheets also have a shortcut available to unhide the rows.

  • Select only those multiple rows within which you only want to unhide rows instead from the entire data set.
  • While the rows are selected, press Ctrl + Shift + 9 keys together (for Windows) or Cmd + Shift + 9 keys together (for Mac) to make the hidden rows visible between those selected rows.
unhide-rows-using-shortcut
  • To unhide all the hidden rows, instead of specific only, you have to select all the rows of the data set as described above.
  • After the all rows got selected, press the Ctrl + Shift + 9 keys together and all the hidden rows will get visible.
Last Updated: May 22, 2024