Something you might find very useful in BIM world, where Excel currently thrives and will continue to do so for the foreseeable(?) future. You need to adjust this option:
And then if a cell references G33, and you double-click on it, it will take you straight to G33.
