Both of these settings can often make it appear that a row or column is hidden when it is simply off screen. You may want to consider unfreezing the panes in your worksheet, or removing a split screen. The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet. If you are still unable to see the first column of the worksheet, then it may not actually be hidden. Unhiding the first column, or column A in an Excel spreadsheet presents a unique challenge. Step 6: Click the Hide & Unhide option, then click Unhide Columns.Ĭolumn “A” should now be visible in your spreadsheet. Step 5: Click the Format button in the Cells section of the Office ribbon. Step 4: Click the Home tab at the top of the window. Step 3: Type “A1” into this field, then press the Enter key on your keyboard. Step 2: Click inside the Name field at the top-left of the spreadsheet. Step 1: Open your spreadsheet in Excel 2010. If you wish to unhide all of the hidden columns in your spreadsheet, then you can follow the steps here. If there are other hidden columns, they will remain hidden. The procedure below will only unhide column “A”. Now you should be able to see column A in your Excel spreadsheet. Select Cells > Format > Hide & Unhide > Unhide Columns. There are a number of ways this can be done: Unhide the entire range and then rehide C:E and G:M. For instance, I may hide columns C:M and want to later unhide column F. If I have an entire range of columns hidden, I find it a bother to unhide a single column out of all those hidden. How do I unhide columns in Excel 2007 Select the Home tab from the toolbar at the top of the screen. I regularly hide and unhide columns in my worksheets. The steps in this article will assume that you have hidden the first column in your Excel spreadsheet. CTRL+0 hides the selected columns in Excel. 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.įortunately it is possible to unhide only the first column in your spreadsheet by following the procedure outlined below. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. In the Editing group, click on the Find button and select 'Go To' from the popup menu.

The typical method for unhiding a column will not apply when the column that is hidden is the leftmost one in the worksheet. Question: How do I unhide row 1 in a sheet in Microsoft Excel 2007 Answer: Select the Home tab from the toolbar at the top of the screen. Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge.

How to unhide a column in excel 2007