There is a white box on the very left hand side of the formula bar (where you enter your functions and calculations). It is directly above column A. Type the cell you wish to go to in that box and hit the return/enter key. EG type A2378 and hit return. This works the same for named ranges you have in the sheet. Type the name of the range you have previously named and hit enter and you will see the range highlighted. Hope this helps.