Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

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.

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.

Make a selection from the menu.

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

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: