Specifying Workbook Properties in Excel 2010
How to Rename an Excel 2010 Worksheet
How to Insert a Hyperlink to a Different Cell in an Excel 2010 Workbook

How to Hide and Unhide Rows and Columns in Excel 2010

You can hide and unhide rows or columns in Excel 2010 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports — hidden rows and columns do not print.

You cannot hide selected cells; only entire columns or rows.


Select the column or row headings you want to hide.

Press the Ctrl key while selecting multiple rows or columns. If you want to unhide rows or columns, select the rows or columns both before and after the hidden rows or columns.


Click the Format button in the Cells group on the Home tab.

Notice the Visibility section of the resulting Format drop-down menu.


Point to the Hide & Unhide command under Visibility in the Format menu.

Another menu appears, containing options for hiding and unhiding rows and columns.


Make a selection from the menu.

When you hide columns or rows, the associated column letters or row numbers disappear from the worksheet frame.

blog comments powered by Disqus
How to Insert a Hyperlink to a File or Web Site in Excel 2010
How to Hide and Unhide Excel 2010 Worksheets
How to Insert a Link to Send an E-mail in an Excel 2010 Worksheet
Dealing with Excel 2010 File Formats
How to Split an Excel 2010 Worksheet Window

Inside Dummies.com