One of the benefits of being Bill Jelen (Mr Excel) is that people send you all kids of tips.
This tips was submitted for consideration for Bill Jelen and Szilvia Juhasz’s book 40 Greatest Excel Tips of All Time.
You have a ton of data, and you are scrolling all over the place. You may have used:
And now maybe you are at the bottom right hand corner of the data. And you know that you could always go to the other corner by using:
This is a beautiful tip. No matter where you are at on your spreadsheet, it will always bring your active cell back into view. Meaning that this will take you from the bottom right of your data (or anywhere else) back to your active cell. This is particularly helpful if you have used your scroll bar to get far removed from your active cell and need to return to the active cell.
Are there any shortcuts that you have found useful? Leave a comment below to join the discussion.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.