Excel Forum

Excel Magic Trick # 161: Go To Tricks Complete Story

See how to highlight all occurrences of an item or Excel element and then change them all quickly
See how to how to Use Go To to select all occurrences of:
Constants "Numbers"
Constants "Text"
Formulas "Numbers"
Formulas "Logical"
Formulas "Text"
Formulas "Errors"
Current Region
Current Array
Visible Cells
Last Cell
Data Validation
Conditional Formatting

See how to use Go To Blanks for the AVERAGE function and Pivot Tables
See how to use Go To Visible Cells Only for Subtotals

See how to delete all imported objects after you copy and paste from the internet!!!

Got a Question? Ask it Here in the Forum.