tech on the net

MS Excel: Unhide column A in Excel 2007

Also learn how to unhide column A in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Before trying the following solution, you might want to make sure that you don't have any frozen panes that you need to unfreeze in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Question: How do I unhide column A in a sheet in Microsoft Excel 2007?

Answer: Select the Home tab from the toolbar at the top of the screen. In the Editing group, click on the Find button and select "Go To" from the popup menu.

Microsoft Excel

When the GoTo window appears, enter A1 in the Reference field and click on the OK button.

Microsoft Excel

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns.

Microsoft Excel

Now you should be able to see column A in your Excel spreadsheet.

Microsoft Excel

Also learn how to hide a column in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.