Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.