How to Show Hidden Columns in Google Sheets: A Step-by-Step Guide

how to show hidden columns in google sheets

Hidden columns can be a bit of a mystery in Google Sheets, but revealing them is quite straightforward. A few clicks here and there, and you’ll have all your data visible again. Let’s walk through the steps to unhide any hidden columns in Google Sheets so you can get back to analyzing your information without any missing pieces.

How to Show Hidden Columns in Google Sheets

In this section, we’ll go through each step to unhide columns in Google Sheets. By the end, you’ll know exactly what to do anytime you come across hidden columns in your spreadsheets.

Step 1: Open Your Google Sheet

First, open the Google Sheets document where you suspect columns might be hidden.

Make sure you have access to the sheet and that it’s the correct one where you need to unhide columns. If you can’t access it, you might need permission from the owner.

Step 2: Select the Columns Around the Hidden Ones

Click on the letters of the columns that are adjacent to the hidden ones.

For example, if columns B and D are visible but column C is hidden, click on the column headers for B and D to select them. This helps you target the hidden columns accurately.

Step 3: Right-Click on the Selected Columns

Right-click on the selected column headers to bring up a context menu.

The context menu provides several options, including one to unhide columns. It’s important to right-click exactly on the column headers to see this menu.

Step 4: Choose "Unhide Columns"

In the context menu, click on the "Unhide Columns" option.

This action will immediately reveal the hidden columns between the ones you selected. If there are multiple hidden columns, they will all be shown at once.

Step 5: Verify the Columns are Visible

Check your sheet to ensure that the previously hidden columns are now visible.

Make sure all your data is intact and that the columns are in the correct positions. If something looks off, you might need to repeat the steps or check for other hidden columns.

After completing these steps, your hidden columns should now be visible in your Google Sheets document. You can continue working with all your data in view.

Tips for How to Show Hidden Columns in Google Sheets

  • Column Headers: Always start by selecting the column headers around the hidden columns. This ensures you target the right area.
  • Multiple Columns: If several columns are hidden, selecting a broader range around the hidden area can help reveal them all at once.
  • Context Menu: Make sure to right-click directly on the column headers. Right-clicking elsewhere won’t bring up the option to unhide columns.
  • Permissions: Ensure you have the necessary permissions to edit the sheet; otherwise, you won’t be able to unhide columns.
  • Alternate Method: You can also go to the "View" menu, select "Hidden sheets," and unhide columns from there if you prefer using menus.

Frequently Asked Questions

How do I know if columns are hidden?

If you see column letters skipping, like going from B to D, columns are hidden in between.

Can I unhide multiple columns at once?

Yes, by selecting the columns around the hidden ones, you can unhide several columns simultaneously.

What if I don’t see the "Unhide Columns" option?

Ensure you’ve selected the column headers correctly. If you still don’t see it, you might not have editing permissions.

Is there a way to unhide columns using the menu?

Yes, go to the "View" menu, select "Hidden sheets," and then choose to unhide the columns.

Can I hide columns again after unhiding them?

Absolutely. You can hide columns by selecting them, right-clicking, and choosing "Hide column."


  1. Open your Google Sheet.
  2. Select the columns around the hidden ones.
  3. Right-click on the selected columns.
  4. Choose "Unhide Columns."
  5. Verify the columns are visible.


And there you have it! Unhiding columns in Google Sheets is as easy as pie. Whether you’re dealing with one hidden column or several, following these steps will help you bring all your data back into view. If you’re often working with large datasets, you might find columns hidden frequently, but now you know how to tackle them without breaking a sweat.

Keep experimenting with the different features Google Sheets offers; they can significantly simplify how you manage your data. If you found this guide helpful, don’t hesitate to share it with others who might benefit from knowing how to unhide columns in Google Sheets. Happy spreadsheeting!