How to Show All Hidden Rows and Columns in Google Sheets

In your large Google Sheets spreadsheets, it’s hard to find rows and columns that are hidden. Luckily, you can use a built-in Google Sheets feature to show all hidden rows and columns at once. We will show you how to use this option.

This option allows you to select all your rows or columns and then choose the ‘unhide’ option to hide all the rows or columns in your selection.

Showing all hidden rows at once in Google Sheets

To view all hidden rows in your spreadsheet, first open your spreadsheet in Google Sheets.

In your spreadsheet, select all the rows that contain data. To do this, next to the first line, click on the number “1”. Then scroll down to the end of your data set. Hold down the Shift key on your keyboard and, next to the last row, click the row number.

Select all applicable rows.

When all of your rows are selected, right click on a row number and choose “Unhide Rows” from the menu.

Select “Unhide Rows” from the menu.

Google Sheets immediately displays all hidden rows in your selection.

All hidden lines are no longer hidden.

There you go, you’re ready.

HOW TO CALCULATE A PERCENTAGE IN GOOGLE SHEETS

Delete all hidden columns at once in Google Sheets

To hide your hidden columns, first open your spreadsheet in Google Sheets.

Select all the columns containing your data. To do this, first click on the letter in your first column (which in most cases is “A”).

Select the first column.

Scroll to the right and find the last column containing your data. Hold down the Shift key on your keyboard and click on the letter in this last column.

You have now selected all your columns.

Select the last column.

To hide hidden columns in your selection, right-click on the letter of a selected column and choose “Hide Columns” from the menu.

Choose “Unhide Columns” from the menu.

And instantly, Google Sheets will show all your previously hidden columns. You have finished.

Leave a Comment