If you wish to navigate quickly on a excel sheet or to select a range, you can use Name box which is there on above side of column A (see attached image for better understanding). Below is the quick method to use this wonder box 
Suppose you wish to go to cell A4000, simply go to name box and type A4000 and press enter. You will be moved to that cell.
Suppose you wish to select the range K500:AC30000, simply go to name box and type K500:AC30000 and press enter, you will find that the range is selected.
Hence the name box helps in quick navigation and quick range selection otherwise it would be cumbersome task to do it manually
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Thanks, its easy