MS Tips and Tricks | Microsoft Excel 2007 | Working with data {Tutorial for beginners}

Affiliates

Amazon.com

Popular Microsoft Excel Books

Excel 2003 Bible

Author: John Walkenbach

Excel 2003 for Dummies

Author: Greg, PhD Harvey

Microsoft Office Excel 2003 Step by Step

Author: Curtis Frye

Excel VBA Programming For Dummies

Author: John Walkenbach

Excel 2003 Personal Trainer

Author: Inc

Microsoft Office Excel 2003 Inside Out

Author: Craig Stinson

Excel 2003 All-in-One Desk Reference for Dummies

Author: Greg Harvey

Popular MS Excel Related Websites

Microsoft Excel 2007 Tutorial for beginners

Welcome to MS Tips and Tricks

Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

Microsoft Excel Tips and Tricks for beginners

20) The filter will hide all rows that do not match with the selected Collect Data text in column Name.

Illustration 18: Filtered Table.

21) To see all rows, open the filter in column Name and Click on Select All option. Press the OK button.

Illustration 19: Restoring view.

22) To exit from the Filter option, de select the Filter option from the Sort & Filter command in the Editing Group.

Illustration 20: De selecting Filtering option.

23) You could filter by other conditions.

Illustration 21: Filters. Click here to view larger image.

24) Select the A2 Cell. Select the Font Color as red.

Illustration 22: Change cell's font color.

25) Select the Filter by Selected cell's Font color option and see the results.

Illustration 23: Filtering by cell's font color.

Advertisement

Your Ad Here

Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster