A quick Excel keyboard trick for selecting large ranges

Share this post!

Vote this!

You probably know about the [F5] key - pressing [F5] opens the Go To dialog. You enter a range name or a cell reference, click OK, and Excel selects a range or cell, accordingly. It’s a quick and easy way to get from one spot to another. What you might not know is that you can use this feature to select a range, where no range exists.          more...