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.

GoTo Box

Excel 2013

  • And in Excel 2007. – Scott Jan 2 '13 at 1:44
  • Should be the same thing... – mdpc Jan 2 '13 at 1:52
  • Thank you that solved my issue! Any chance you would have an answer to my other question - which is listed under: Strange behavior of left arrow key in Excel 2010 – ctsgoofy Jan 2 '13 at 17:31
  • I did some checking and I'm unable to reproduce the behavior that you described. I'm glad to have been a help with this one. If you could mark the answer as Accepted, I'd appreciate it. – BillP3rd Jan 2 '13 at 21:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.