You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you.
Approach 1 - Put the range in Name Box and Press Enter
1. Press F5 (or CTRL+G)
2. Specify the range in Reference:
3. OK and you range is selected.