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 :)



One thought on “Name Box for quick navigation and range selection

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>