How To Unhide Columns In Google Sheets

At times, you may want to hide specific columns in your Google Sheets to ensure the readability and conciseness of your data. But what happens when you need to access that hidden data again? Mystery solved! In this blog post, we’ll walk you through the surprisingly simple process of unhiding columns in Google Sheets.

The Need to Unhide Columns

Whether you’re dealing with a spreadsheet full of data or a simple budget, hidden columns in Google Sheets can temporarily remove unnecessary or overwhelming information from view. However, you may need to unhide these columns for various reasons — viz. to update or review the data, to use formulas that reference the hidden cells, or just because you want all your data visible. No matter what your reason, let’s get those columns back into view!

The Process of Unhiding Columns in Google Sheets

Unhiding columns in Google Sheets is a straightforward task. Here’s what you need to do:

  1. Open your Google Sheets document.
  2. Identify the hidden columns. These are typically indicated by a pair of arrows in the column headers. For example, if column B is hidden, you’ll see arrows between columns A and C.
  3. Click on the arrows to unhide the column.

That’s it! Your hidden column should now be visible.

Unhiding Multiple Columns in Google Sheets

Unhiding multiple columns at once is just as simple. Follow these steps:

  1. Open your Google Sheets document.
  2. Select the columns on either side of the hidden columns. For example, if columns B and C are hidden, select columns A and D.
  3. Right-click on either of the selected columns and choose “Unhide columns.”

Voila! You’ve now successfully unhidden multiple columns.

Unhiding All Columns in Google Sheets

If you want to unhide all hidden columns at once, follow these steps:

  1. Click on the rectangle in the top left corner of your Google Sheets to select all cells.
  2. Right-click on any column header and choose “Unhide columns.”

All hidden columns are now visible!


Unhiding columns in Google Sheets is an incredibly simple process, whether you’re unhiding a single column, multiple columns, or all hidden columns at once. Just a few clicks and your data is back in view, ready for you to work with. So go ahead, unhide those columns and dive back into your data!


Follow the Google Sheets Help Center link for more information and support: