Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Displaying a Hidden First Column.

Displaying a Hidden First Column

by Allen Wyatt
(last updated April 16, 2019)


Excel makes it easy to hide and unhide columns. What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet. For instance, if you hide column A, Excel will dutifully follow out your instructions. If you later want to unhide column A, the solution isn't so obvious.

To unhide the left-most columns of a worksheet when they are hidden, follow these steps:

  1. Press F5. Excel displays the Go To dialog box. (See Figure 1.)
  2. Figure 1. The Go To dialog box.

  3. In the Reference field at the bottom of the dialog box, enter A1.
  4. Click on OK. Cell A1 is now selected, even though you cannot see it on the screen.
  5. Make sure the Home tab of the ribbon is displayed.
  6. Click the Format tool in the Cells group, then choose Hide & Unhide, then Unhide Columns.

Another way to display the first column is to click on the header for column B, and then drag the mouse to the left. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected. You can then display the Home tab of the ribbon and click Format | Hide & Unhide | Unhide Columns.

A third method is even niftier, provided you have a good eye and a steady mouse pointer. If you move your mouse pointer into the column header area, and then slowly move it to the left, you notice that it turns into a double-headed arrow with a blank spot in the middle as you position the pointer over the small area immediately to the left of the column B header. This double-headed arrow is a bit difficult to describe; it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them.

When your mouse pointer changes to this special double-headed arrow, all you have to do is right-click and choose Unhide. Your previously missing column A magically reappears.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9012) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Displaying a Hidden First Column.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Print Preview Freezes Word

It can be frustrating if the Word program freezes when you are trying to work with a document. If this happens to you, ...

Discover More

WindowsTips 2016 Archive (Table of Contents)

WindowsTips is a weekly newsletter that provides tips on how to best use the Windows operating systems. At the ...

Discover More

Getting Rid of "Comment" in Comments

When you add a comment to a document, Word presents that comment in a very specific way. If you want to change the way in ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More ExcelTips (ribbon)

Weird Actions for Arrow Keys and Enter

If your arrow keys and the Enter key aren't working as you expect them to, the problem could have any number of causes. ...

Discover More

Displaying a Count of Zeros on the Status Bar

Excel allows you to display the results of several common worksheet functions on the status bar. The available functions ...

Discover More

Grabbing a User's Name from Excel

One of the settings you can make in Excel is to specify a user's name. This name is accessible through macros, and can ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is eight more than 3?

2018-07-04 07:21:39

Willy Vanhaelen

It is not necessary to specify the range of columns or rows.
This macro handles the entire sheet and so it works in Excel <=2003 as well.

Sub Seeme()
Columns.EntireColumn.Hidden = False
Rows.EntireRow.Hidden = False
End Sub

[A1] is a shortcut for Range("A1")

2018-07-03 09:06:27

Jennifer Thomas

One other way is to select the whole worksheet and then, in the Home tab's Cells group, click the Format drop down arrow | click Hide & Unhide | click Unhide Columns. That's an easy way to 'start over' with hidden columns, but if you just want to unhide A, go with Allen's advice above!

2018-07-03 07:54:17


Or use a macro to see everything.

Sub Seeme()
Columns("A:XFD").EntireColumn.Hidden = False
Rows("1:1048576").EntireRow.Hidden = False
End Sub


2018-07-03 06:40:57


Placing the mouse in header of column B, left clicking and dragging to left, then right clicking header of column B and selecting unhide also works.

2018-07-03 06:13:47

Dave Roberts

A fourth way of unhiding single columns works best for me. I regularly autofit columns and sometimes the column goes beyond the size of the window. Instead of scrolling to the right, I added the Column Width icon to my QAT. I press that and put in a usable column width.

For a hidden column, I put the column letter and 1 in the Name Box, i.e. A1. I then press Column Width and add a width greater than 0.

2016-07-20 11:27:40


In response to the 3rd method, ones you have the double-headed arrow, you don't need to right click->unhide. Simply clicking and dragging to the right will also display column A.

2016-03-26 07:51:16

Willy Vanhaelen

Perhaps your comumn A has a width of 0 (zero). Then you cannot see it but it is not hidden.

Use the first method and in 5. select "Column Width..." instead of "Hide & Unhide" and enter a number > 0.

2016-03-25 11:46:11


I've tried all three of these ideas to display the first column and none of them will work. Any other ideas? Thanks.

2015-10-26 01:21:09

Alexandre Barbier

I had devise another step to UNhide my lost Column A: I had to first HIDE B and left, THEN UNhide and A finally reappeared.
Could there LEVELS of Hide/UnHide?

2015-07-01 20:48:26


I tried every ones tips and nothing worked until I unfroze panes. Many thanks Nathan

2015-06-02 10:47:11


In my previous post I forget to identify where I got the macro. It is from a pdf file called ExcelTips. this is a weekly newsletter.

2015-06-02 10:44:07


I regularly hide and unhide columns in my worksheets. If I have an entire range of columns hidden, I find it a bother to unhide a single column out of all those hidden. For instance, if I hide columns C:M, and I want to unhide column F, then I need to unhide the entire range and then rehide C:E and G:M. (There are other ways I could accomplish the same task, but none of them are particularly endearing.)
However, I find that a single column can be unhidden very easily using a macro. Consider the following:
Sub UnhideSingleColumn()
Dim Col As String
Dim rng As Range

Col = InputBox("Enter column to unhide.", "Unhide Column")
If Col = "" Then Exit Sub
On Error Resume Next
' if not a valid range, an error occurs
Set rng = ActiveSheet.Columns(Col)
If Err.Number <> 0 Then
On Error GoTo 0
MsgBox "Invalid input! Please input a valid column."
GoTo StartHere
End If

rng.EntireColumn.Hidden = False

MsgBox "Column " & UCase(Col) & " is now visible.", _
vbOKOnly, "Unhide Specified Column"
Set rng = Nothing
On Error GoTo 0
End Sub

The macro prompts the user for which column should be made visible, and then tries to select that column. If the column cannot be selected, then an error is generated and the user is again asked for input. If the column can be selected, then its .Hidden property is turned off, thereby making the column visible.

2015-02-18 16:06:49

Ross Goodell

Nathan's comment about the Freeze Panes solved it for me. None of the rest had worked, so I tried unfreezing panes and then selecting cell A1 and doing the rest of method 1 above. That worked. Thanks.

2014-05-31 00:39:03


Thanks for the clear instructions. I need to do this a number of times on different reports each month and I've been struggling to understand why some techniques seem to work some times and not at other times.

2014-05-28 14:17:40


Nathan, you just saved my life!!

2014-01-21 17:30:46


This is the very reason I only EVER group columns - I never hide columns or rows - at least with the "+" at the top, I can still manipulate the columns and I am reminded they are there.

2014-01-14 09:12:58


The only problem with Kim's and Karen's option are if you do not want to unhide all the columns, just column A. I always did the double-headed arrow method.

2014-01-13 10:45:31


You can also select all, right click on the column header, and click unhide

2014-01-11 10:13:32


Why not this: by clicking the top left corner of the ss, above the intersection of column A and row 1, the entire spreadsheet is selected and you can now unhide all hidden columns and rows at once. (This is the only advised use of selecting the whole spreadsheet I can think of!)

2014-01-11 09:04:00

Nathan Dane

Additionally, the column may sometimes appear hidden, but has actually been inadvertently locked offscreen through Freeze Panes.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.