How to go to a specific cell in a large worksheet???

[Austintx1]

Hi, I have a large worksheet and I want a quick way to get to the top or bottom of the spreadsheet without scrolling up and down all day. I know I can press "Control, Home" to get to the top of the spreadsheet, but how do I get to the bottom quickly and easy? what do I do to get to Cell E697 with the press of one key??

thank you for your help!

 

[mumps]

"Control, End"

 

[Austintx1]

"Control, End"

thank you for your reply. Control End takes me to the very bottom of the spreadsheet. how do I go to a specific cell?

 

[mumps]

You can't get to a specific cell with a keyboard entry. You would need a macro and we would need to know the location of the specific cell.

 

[Austintx1]

thank you. Not sure what a macro is, but the specific cell I am wanting to go to is E697. do you have any ideas for me?

 

[jlopj]

to the left of the formula bar at the left most edge is a box containing the "address" of the current cell selection. You can edit that address to change the current cell selection. Type your "address" E697 in that box and press enter -- the excel screen will update and move there.

also you press the F5 key -- that will open the go to function.
Type your "address" E697 in that box and press enter -- the excel screen will update and move there.

 

[mumps]

@jlop has provided you with a useful solution.

 

[Austintx1]

to the left of the formula bar at the left most edge is a box containing the "address" of the current cell selection. You can edit that address to change the current cell selection. Type your "address" E697 in that box and press enter -- the excel screen will update and move there.

also you press the F5 key -- that will open the go to function.
Type your "address" E697 in that box and press enter -- the excel screen will update and move there.

thank you for your help. when I press the F5 key nothing happens. this appears to be a key to only light up my keyboard or not. am I doing something wrong?

can I set up a formula to where if I press F5 it will automatically go to the specific cell I want? just don't want to keep scrolling up and down all day.