How to Hide/Unhide in Excel 2007

By Bonnie Conrad

One of the most useful functions in Microsoft Excel 2007 is the ability to hide rows and columns without deleting them. The ability to hide and unhide cells at will allows spreadsheet creators to highlight certain data for end users, while eliminating other data that those end users do not use. Hiding and displaying cells also makes it easier to create detailed formulas without sacrificing the usefulness of the spreadsheet. The process used to hide and unhide columns and rows in Excel 2007 is somewhat different than what was used in Excel 2003, so new users will need to take the proper steps.

Step 1

Log on to your computer and open Microsoft Excel 2007. Open the spreadsheet.

Step 2

Select a cell within the row or column you wish to hide. Click on the "Cells" group and choose "Format".

Step 3

Go to the "Visibility" section and choose "Hide" or "Unhide" from the menu.