Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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

share|improve this answer
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 posting your answer, you agree to the privacy policy and terms of service.

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