How to Unhide Column “A” in Excel 2010

Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge. The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet.

An alternative would be to simply unhide all of the columns that are hidden in the spreadsheet, but this can be problematic if there are other columns that you wish to remain hidden.

Fortunately it is possible to unhide only the first column in your spreadsheet by following the procedure outlined below.

Unhiding the First Column in Excel 2010

The steps in this article will assume that you have hidden the first column in your Excel spreadsheet. The procedure below will only unhide column “A”. If there are other hidden columns, they will remain hidden. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Click inside the Name field at the top-left of the spreadsheet.

click inside the name field

Step 3: Type “A1” into this field, then press the Enter key on your keyboard.

enter a1

Step 4: Click the Home tab at the top of the window.

click the home tab

Step 5: Click the Format button in the Cells section of the Office ribbon.

click the format button

Step 6: Click the Hide & Unhide option, then click Unhide Columns.

unhide the columns

Column “A” should now be visible in your spreadsheet. If you are still unable to see the first column of the worksheet, then it may not actually be hidden. You may want to consider unfreezing the panes in your worksheet, or removing a split screen. Both of these settings can often make it appear that a row or column is hidden when it is simply off screen.

Now that you know how to unhide column A in Microsoft Excel 2010, you can use this method to view and edit the content contained within those cells.

Note that this same method will also work to unhide the first row of your spreadsheet, except you will need to select the Unhide Rows option in Step 6 instead.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy