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

If you've applied color to fonts or cells in an Excel 2010 table, you can filter the table to display a subset of the data with the colors you specify. The rows that do not match the criteria you specify are hidden temporarily.

Excel 2010 tables automatically display filter arrows beside each of the column headings. To display the filter arrows so that you can filter data, format a range as a table using the Table button on the Insert tab. Or, you can click the Filter button in the Sort & Filter group on the Data tab.

Click the filter arrow for the column by which you want to filter data.

The filter drop-down list appears.

Point to Filter by Color in the drop-down list.

Point to Filter by Color in the drop-down list.

A submenu of color options appears. You can filter by Cell (background) Color or by Font Color. The submenu you see depends on the color choices in your data.

Select an option.

Excel displays the table using the filter you requested.

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: