How To Unhide Columns In Google Sheets

To unhide columns in Google Sheets, select the columns adjacent to the hidden columns, right-click and choose “Unhide columns” from the dropdown menu.

Google Sheets is an incredibly powerful tool that makes it easy to organize, analyze, and manipulate data. One handy feature of this spreadsheet software is the ability to hide columns temporarily, which can be useful when you want to focus on specific data or reduce clutter. However, there may come a time when you need to unhide those hidden columns. In this blog post, we will walk you through the step-by-step process of how to unhide columns in Google Sheets, so you can effortlessly bring back any hidden data and regain full visibility of your spreadsheet. Let’s dive in and uncover this useful feature!

How To Unhide Columns In Google Sheets: Step-by-Step


Step 1: Open Google Sheets

To unveil hidden columns in Google Sheets, simply sign into your Google account on the website or app. Locate the sheet with the hidden columns and reveal them to access the data.

Next Step

Step 2: Identify Hidden Columns

Hidden columns in a spreadsheet are denoted by two lines (or arrows) in the column header bar, visually separating them from the visible columns. These lines indicate that there are hidden columns in between, which aren’t currently visible on the screen.

Next Step

Step 3: Select the Columns Around the Hidden One

Click and drag to select the columns on either side of the arrows, including the arrows. If column B is hidden, select columns A and C.

Next Step

Step 4: Right Click on the Selected Columns

From the context menu that appears after right-clicking on any selected columns adjacent to the hidden one, you can access various options and functionalities related to the columns, allowing for efficient management and customization.

Next Step

Step 5: Select ‘Unhide Columns’

In the context menu, go to ‘Unhide columns’ and select it. This action will restore the hidden columns, allowing you to access them once more.


In this blog post, we’ve explored the simple yet powerful feature of unhiding columns in Google Sheets. Whether you’re working on a complex spreadsheet or just need to bring back some hidden data, knowing how to unhide columns can save you time and frustration. By following the easy steps outlined, you can effortlessly reveal hidden columns and regain access to the information you need. So, the next time you find yourself struggling to locate a column in Google Sheets, remember the techniques discussed here and unhide with confidence. Happy spreadsheeting!

Table of Contents