Additional Formatting	Cell Alignment and Orientation Borders Centering Text Across Columns Hiding and Unhiding Columns and Rows
Conditional Formatting	Formatting Based on Values and Multiple Conditions Avoiding Overlapping Conditions Using a Formula to Control Formatting
Specialized Numeric Formatting	Custom Category Special Category
Cell References	Absolute References Mixed References
Range Names	Naming and Using Range Names Additional Creation Methods Pasting a List of Range Names in a Worksheet Deleting Range Names Assigning a Name to a Value
Formula Auditing Techniques	Using the Formula Auditing Toolbar Tracing Dependent Cells Tracing Precedent Cells
Cell Protection Techniques	Locking/Unlocking Selected Cells Protecting/Unprotecting a Worksheet
Find and Replace	Matching Entire Cells and Case Factors Formulas and Wildcard Characters Find and Replace by Format
Adjusting Worksheet Views	Freeze/Unfreeze Panes Horizontal and Vertical Split Screens
Customizing Toolbars	Adding and Removing Buttons Economizing Buttons and Resetting Toolbars Creating New Tool Bars