Name Box for quick navigation and range selection

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 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.