How To Unhide Columns In Excel

Working with Excel often involves hiding columns to make your data easier to read or to prepare a sheet for printing. But what happens when you need that data back? This guide provides clear, practical steps to unhide columns in any Excel spreadsheet. We cover everything from the basic right-click method to special techniques for unhiding the first column or dealing with protected sheets. Whether you're a beginner or just need a quick reminder, these instructions will help you reveal your hidden data in moments.

Fast Answer

Select Columns: Click and drag over the column headers on either side of the hidden column(s).
Right-Click: Right-click on the selected column headers.
Choose Unhide: Select "Unhide" from the context menu.

Under 1 minute Time needed

Beginner Difficulty

Protected sheets Watch out for

Before You Start

Microsoft Excel: You will need a computer with a working version of Microsoft Excel installed. These steps apply to Microsoft 365, Excel 2021, 2019, and most other recent versions.
The Excel File: Have the workbook with the hidden columns open and ready.
Basic Mouse Skills: You should be comfortable with left-clicking, right-clicking, and dragging to select cells or columns.

Check first: If you are unable to make changes, your worksheet might be protected. Navigate to the Review tab on the Excel ribbon. If you see a button that says Unprotect Sheet, you will need to click it (and possibly enter a password) before you can unhide columns.

Step-by-Step Instructions

Method 1: The Standard Right-Click Method

This is the most common and quickest way to unhide one or more columns when you can see where they are hidden. Hidden columns are indicated by a thin double line between the column headers where the hidden columns should be. For example, if column B is hidden, you will see a double line between the headers for column A and column C.

Locate the hidden columns. Look at the column letters at the top of your sheet (A, B, C...). If the letters skip (e.g., A to C, or D to G), you have hidden columns in that gap. You will also see a slightly thicker line, or a double line, between the headers of the visible columns.
Select the surrounding columns. Click on the header of the column just to the left of the hidden ones. Hold down the mouse button and drag your cursor to the right to also select the column just to the right of the hidden ones. For example, to unhide column B, you would select both columns A and C. Your selection must span across the hidden area.
Right-click and Unhide. Move your mouse cursor over the selected column headers, then right-click. A context menu will appear.
Click on the Unhide option from the menu. The hidden columns between your selection will instantly reappear.

Tip: If you only need to unhide a single column, you can carefully move your cursor over the double-line indicator. Your cursor will change to a double-headed arrow with two vertical lines. Double-click at this exact spot to unhide the column to the left.

Method 2: Using the Home Tab Ribbon Menu

If you prefer using the ribbon menu at the top of Excel or find right-clicking awkward, this method achieves the same result. It's a reliable alternative that provides a clear path to the command.

Select the surrounding columns. Just as with the right-click method, you must first select the columns that are on either side of the hidden ones. Click and drag across the column letters (e.g., A and C) to select them.
Navigate to the Home tab. Make sure the Home tab is active on the Excel ribbon at the top of the window.
Find the Format button. Look towards the right side of the Home tab, in the Cells group. Click on the Format button. A dropdown menu will appear.
Select Hide & Unhide. In the Format dropdown menu, hover your mouse over the Hide & Unhide option. This will open a sub-menu.
Click Unhide Columns. From the sub-menu, select Unhide Columns. Excel will immediately unhide any columns within your selected range.

Method 3: How to Unhide All Columns on a Worksheet

Sometimes you might not know exactly which columns are hidden, or there might be several hidden columns scattered across a large sheet. In this case, the fastest approach is to unhide everything at once.

Select the entire worksheet. To do this, click the Select All button. This is the small grey triangle in the top-left corner of the worksheet, located at the intersection of the row numbers and column letters. Clicking this button selects every cell in the sheet.
Use the Home tab menu. With the entire sheet selected, go to the Home tab.
Navigate to the Cells group and click Format.
Hover over Hide & Unhide, and then click on Unhide Columns.

Alternatively, after selecting the entire worksheet, you can also right-click on any of the column headers (A, B, C...) and choose Unhide from the context menu. This action will reveal every hidden column on the sheet, no matter where it is located.

Method 4: The Special Case of Unhiding Column A

Unhiding the very first column, Column A, can be tricky because you can't select a column to its left. This common problem has a couple of simple solutions.

Option 1: Using the Name Box

Go to the Name Box. The Name Box is the small input field to the left of the formula bar. It usually displays the address of the currently selected cell (e.g., B2).
Type "A1" and press Enter. Click inside the Name Box, type A1, and press the Enter key on your keyboard. This will select cell A1, even though its column is hidden.
Use the Format Menu. Now that a cell in the hidden column is active, go to the Home tab, click Format in the Cells group, hover over Hide & Unhide, and select Unhide Columns. Column A will reappear.

Option 2: Using the Mouse

Position your mouse carefully. Move your mouse cursor to the left edge of the Column B header.
Wait for the cursor to change. As you hover over the border between the row number area and the Column B header, your cursor should change into a double-headed arrow with two vertical lines.
Click and drag right. Once the cursor changes, click and hold the left mouse button, then drag slowly to the right. This will "pull" Column A back into view. You can also simply double-click when the special cursor appears.

Method 5: Setting a Specific Column Width

This method forces hidden columns to reappear by giving them a width greater than zero. It is especially useful when columns are not truly hidden (width = 0) but are just so narrow that they appear hidden.

Select the surrounding columns. Click and drag to select the columns on either side of the column(s) you want to reveal.
Open the Column Width dialog box. Go to the Home tab on the ribbon.
In the Cells group, click the Format button.
From the dropdown menu, select Column Width.... A small window will pop up.
Enter a new width. In the dialog box, type a standard column width number, such as 10, and click OK. Any hidden columns within your selection will be resized to this new width, making them visible.

Tip: The default column width in Excel is typically 8.43 characters. Entering any positive number will work, but using a value like 8 or 10 is a good starting point.

Quick Reference

Situation	Use this	Why
Unhiding a few specific columns	Right-Click Method	It's the fastest and most direct way for targeted unhiding.
The first column (Column A) is hidden	Name Box Method ("A1")	This is the most reliable way to select the hidden column when you cannot click to its left.
Many columns are hidden everywhere	Select All + Unhide Command	This reveals every hidden column on the sheet in two clicks, saving you from hunting them down.
The "Unhide" option is greyed out	Review > Unprotect Sheet	This command is disabled on protected sheets. You must remove protection first.

Common Problems When You Unhide Columns In Excel

Sometimes things don't go as planned. Here are solutions to the most common issues you might encounter when trying to unhide columns.

The "Unhide" Option is Greyed Out or Inactive

Cause: The most likely reason for the Unhide command being unavailable is that the worksheet is protected. Sheet protection can be configured to prevent users from changing formatting, which includes unhiding columns.

Solution: Go to the Review tab on the Excel ribbon. Look for a button that says Unprotect Sheet. If it's there, click it. You may be prompted to enter a password if the sheet was protected with one. Once the sheet is unprotected, you should be able to use any of the unhiding methods successfully.

I Unhid Columns, but They Still Seem to be Missing

Cause 1: Data Filtering is Active. If a filter is applied to your data, it might be hiding rows, which can give the appearance of missing data even after columns are unhidden. More importantly, some filter actions can hide columns as well, especially in complex tables.

Solution 1: Go to the Data tab. In the Sort & Filter group, look for a highlighted Filter button. You can also click the Clear button in this same group to remove all active filters from the data range.

Cause 2: The Column Width is Extremely Small. A column might not be technically hidden (width of 0) but may have its width set to a tiny value like 0.05. It will be invisible to the naked eye but won't respond to the "Unhide" command.

Solution 2: Select the columns around the "missing" one, go to Home > Format > Column Width, and enter a standard number like 10. This forces the column to a visible size.

I Can't Unhide Columns on Multiple Grouped Sheets

Cause: When you have multiple worksheets grouped together (by holding Ctrl or Shift and clicking their tabs), certain formatting actions like unhiding are disabled to prevent accidental changes across all sheets at once.

Solution: Look at the sheet tabs at the bottom of your Excel window. If they are grouped, they will appear highlighted in white. Right-click on any of the grouped tabs and select Ungroup Sheets from the menu. Once ungrouped, you can navigate to the individual sheet and unhide the columns as normal.

Advanced Tips for Unhiding Columns In Excel

Once you've mastered the basics, these advanced techniques can help you manage column visibility more efficiently.

Use Keyboard Shortcuts for Speed

Keyboard shortcuts can significantly speed up your workflow. The traditional shortcut for unhiding columns is Ctrl + Shift + 0 (zero). However, be aware that this shortcut is often used by Windows to change the keyboard layout and may not work on all systems.

A more reliable keyboard method is to use the ribbon's access keys:

Select the columns surrounding the hidden ones.
Press Alt on your keyboard. Letters will appear over the ribbon tabs.
Press H for the Home tab.
Press O for the Format menu.
Press U for Hide & Unhide.
Press L for Unhide Columns.

So, the full sequence is Alt, H, O, U, L. It seems long, but with practice, it's very fast.

Work with Grouped and Outlined Data

If you see small plus (+) and minus (-) signs above the column headers, it means the columns are part of an outline group. This feature is used to quickly collapse and expand sections of a report.

Instead of using the standard unhide methods, simply click the + symbol to expand and reveal the hidden grouped columns. This is the intended way to interact with outlined data and preserves the structure of the sheet. You can create these groups yourself by selecting columns and going to the Data > Group command.

Use the Document Inspector to Find Hidden Elements

In a very large or unfamiliar workbook, you might not even be sure if there are hidden columns. You can use a built-in Excel tool to check.

Go to File > Info.
Click the Check for Issues button and select Inspect Document.
In the Document Inspector window, make sure the box for Hidden Rows and Columns is ticked, then click Inspect.
The results will tell you if any hidden rows or columns were found on the sheet. While this tool won't unhide them for you (it offers to remove them, which you should not do!), it's an excellent way to confirm their existence before you start searching.

How To Unhide Columns In Excel FAQ

Why would someone hide columns in Excel?

People hide columns for several reasons: to make a large dataset easier to view by removing irrelevant information temporarily, to hide intermediate calculations or helper columns from a final report, or to format a sheet specifically for printing so that only certain data appears on the page.

Is unhiding a column the same as unfiltering?

No, they are different actions. Hiding is a manual formatting choice applied to the entire column. Filtering is a data-driven action that hides rows based on criteria within one or more columns. If data is missing and you don't see any skipped column letters, you likely need to clear a filter on the Data tab.

Can I unhide columns in the online version of Excel?

Yes. The process in Excel for the web is nearly identical to the desktop version. You can select the columns on either side of a hidden column, right-click the header, and choose "Unhide Columns". The ribbon commands on the Home tab are also available.

Does unhiding columns affect my formulas or data?

No. Unhiding a column simply changes its visibility. All data, formulas, and cell formatting within that column are preserved and will be exactly as they were before the column was hidden. Formulas that reference cells in the hidden column will continue to work correctly whether the column is hidden or visible.

How can I prevent other users from unhiding columns?

The only effective way to prevent users from unhiding columns is to protect the worksheet. Go to the Review tab and click Protect Sheet. You can set a password and choose which permissions to allow. By default, protection prevents changes to column and row formatting, which includes hiding and unhiding.

Final Checklist for Unhiding Columns In Excel

Look for gaps in column letters (e.g., A, C, D) or double lines between headers to locate hidden columns.
Select the columns on both sides of the hidden section by clicking and dragging on the headers.
Use the right-click menu and choose Unhide for the quickest method.
Alternatively, use the ribbon path: Home > Format > Hide & Unhide > Unhide Columns.
For the hidden first column (Column A), use the Name Box to type A1 and press Enter before using the Format menu.
If unhiding does not work, check the Review tab to see if you need to Unprotect Sheet first.
After successfully revealing your data, remember to save your file to keep the changes.