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:
Objects
Comments
Constants "Numbers"
Constants "Text"
Formulas "Numbers"
Formulas "Logical"
Formulas "Text"
Formulas "Errors"
Current Region
Current Array
Blanks
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.