How to Unhide Columns in MS Excel 2007


Microsoft Excel 2007 displays all of your spreadsheet content by default. However, if you do not want to print certain columns, or wish to hide selected sections of data from others who have access to the document, the program gives you the ability to do so. When you no longer need this type of formatting, Excel also allows you to redisplay columns you previously hid---although the required steps are not immediately obvious. Fortunately, once you know how to properly select columns and locate the necessary menu command, redisplaying hidden columns requires just a few clicks.

Using the Ribbon

  • 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.

  • Select the "Home" tab from the Office Ribbon near the top of the window and then locate the "Cells" section of the Ribbon.

  • Click the "Format" button, select "Hide & Unhide" and then click the "Unhide Columns" option.

Using the Right-click Menu

  • Look to the column ID row at the very top of your spreadsheet.

  • 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.

  • Right-click and select the "Unhide" option.

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!