How To Unhide Columns in Google Sheets

Google Sheets allows you to hide and unhide columns just like any other spreadsheet program. Often the reason for hiding columns is to better organize your document and data. For example, you may have columns with formulas or calculations that you don’t need to see all the time. You may also have columns with a lot of necessary information, but it extends so far that you have a scroll to see the end of your sheet. Hiding columns can make it easier to view the data in your sheet. But once you hide them you may need to unhide them so you can edit or review the data within. So how do you unhide the columns in Google Sheets?

There are two very simple ways to unhide columns in Google Sheets. It works the same way on a Mac, PC, or the Google Sheets app on your mobile device. Both ways to unhide the columns take very few steps and are super easy to learn and remember. Neither way is more efficient than the other – both ways will still make your columns appear. In the end, it comes down to which way you remember when you need to unhide columns.

How to Unhide Google Sheet Columns

You will know that a column, or several columns, are hidden in Google Sheets in two ways. The first sign of hidden columns is that the lettered cell will be missing. For example, the columns will jump from D to M. The columns and all the data within them will be hidden. The second way you will know there are hidden columns are the small arrows on either side of the hidden column labels.

The first way to unhide a column is to click or tap the small arrow on either side of the hidden column. This will make the hidden columns and all the information immediately reappear. This is the easiest way to unhide columns. However, the second way to unhide columns is not very complicated either.

If you are on a desktop and need to unhide columns in Google Sheets you can follow the easy steps below.

  1. Click on the column heading next to the hidden columns.
  2. Drag your cursor to the right until you have highlighted the column on the other side of the hidden ones.
  3. Right-click anywhere on the highlighted column headings.
  4. A menu will appear. Click on Unhide Columns.
  5. Your columns and all the information within them will immediately show up again.

Google Sheets is a very easy program to use and access. As long as you have an internet connection you can use Google Sheets on your laptop, desktop, or mobile device through the Google Sheets app. You can unhide columns in two very easy ways. Neither of the processes takes a lot of steps to complete. They both make your columns appear without messing up your sheet or the data within. But now you know the short cut and how to unhide them the official way.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.