So I want to be able to select a range to work with - for example A1 to ZZ200. Without having to highlight that whole area is there some way that I can just type in the range that I want to work with?? I'm looking for something like the CTRL G goto button.
Yes. In fact, you can do it by pressing CTRLG as shown below. You can also click in the box in the second image, type in the range, and press ENTER.
See the imagse below from Excel 2013. It works exactly the same way in 2010.