-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
shortcut
- Thread starter afdmello
- Start date
BlueHornet
Active Member
- Joined
- Apr 13, 2012
- Messages
- 341
I'm not sure that there's a single answer to this question, because like a lot of other answers "it depends".
For me, End and Home, pressed serially (the second one after pressing and releasing the first) takes me to "the bottom right corner of the range of 'all active or previously active' cells on the worksheet". That may not be a row that currently has text or any entry, however.
For a table of cells all filled with data, then End and Down Arrow take me to "the last cell with an entry in a column of cells" (or if I'm pressing that in a blank area of the worksheet or table, then it takes me to 'next filled cell').
Performance may also depend on how you have Excel set up (or if you have it set up) with "alternate navigation keys".
For me, End and Home, pressed serially (the second one after pressing and releasing the first) takes me to "the bottom right corner of the range of 'all active or previously active' cells on the worksheet". That may not be a row that currently has text or any entry, however.
For a table of cells all filled with data, then End and Down Arrow take me to "the last cell with an entry in a column of cells" (or if I'm pressing that in a blank area of the worksheet or table, then it takes me to 'next filled cell').
Performance may also depend on how you have Excel set up (or if you have it set up) with "alternate navigation keys".
Upvote
0
Similar threads
- Solved
- Question
