Microsoft 065-04940 - Office Excel 2007, User Manual, Page: 18 / 37

www.microsoft.com/office/excel 15
 View existing rules. You can view the rule condition, the range it is applied to, and
the format set on the rule. The
Show Formatting Rules for drop-down menu at
the top of the dialog box enables you to change the scope of the rules you are
looking at. You can view rules for the selected cells, the current worksheet, the
current table, other worksheets in the book, other tables in the workbook, or the
entire workbook.
 Add new rules via the New Rule button.
 Change the order in which rules are evaluated. This is done using the UP ARROW
and DOWN ARROW keys.
 Edit existing rules via the Edit Rule button. The Edit Rule UI is the same as the
New Rule UI.
 Delete rules via the Delete Rule button.
 Control whether more than one rule can evaluate to true.
Improved Sorting and Filtering
Sorting and filtering are two of the most important types of basic analysis that you can
do with data. New options for sorting and filtering make Office Excel 2007 the ideal tool
for working with large amounts of complex data. You can:
 Select any number of items for filter conditions with multi-select in AutoFilters.
 Sort or filter by the background color of cells.
 Filter by applying “quick filters” for specific data types (for example, filter by
quarter, month, or year for a date column).
 Reapply a set of filters with one button click.
 Manage up to 64 sorting levels from a central location.