Thursday, October 13, 2011

How to Unhide Columns in MS Excel 2007


Using the Ribbon
1. Highlight at least one cell on each side of the column you want to redisplay. For example, if you are trying to unhide column E, highlight a cell in both column D and F.
2. Select the 'Home' tab from the Office Ribbon near the top of the window and then locate the 'Cells' section of the Ribbon.
3. Click the 'Format' button, select 'Hide Unhide' and then click the 'Unhide Columns' option.
Using the Right-click Menu
4. Look to the column ID row at the very top of your spreadsheet.
5. Hold your cursor over the left edge of the column ID located immediately to the right of the hidden column you want to reveal. For example, if you are trying to unhide column A, hold your cursor over the left edge of column B in the column ID row. A double-sided arrow will appear when your cursor is in the proper position.
6. Right-click and select the 'Unhide' option.

Blogger news