Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.