32. Excel Tips - Using Go To

Nick's picture

This is a follow-on from Tip 31

So, you've entered all your range names and now you would like to go to one of them and you can't remember where it is.

Step1:
Press CTRL + g
This brings up the Go To menu:
Go To
- note all the range names are listed and you can select any of them to go to that range.
- you can either click on a name or type in a range reference like B2:C30

Step2:
There is also another very useful menu available if you choose "Special"
Go To

Video Training on how to use GO TO: