Active cell is D5, to select complete row, type 5 in the NameBox and hit Enter

17. Create a Name to the Range

Select the range, say D5:E10, type a name in the name box. when ever you select the range D5:E10, the name given to this range will appear in the NameBox.

18. Navigating Back to Active Cell, Collapsing a Range

Say, the range D5:E10 is selected and to navigate back to active cell say active cell is D5 in this range, just type RC in the NameBox and hit enter to see the range get collapsed and active cell D5 get selected.

Most of us doesn't know these many features available in NameBox right? No issues, even I know these yesterday. So, eager to share it with you.

That's all from me now, see you the next day.

DID YOU USE NAMEBOX?

Please share your experiences about the NameBox and its usages in your work place. If you like this post, please do share it and like it by clicking on the social networking sites placed around the blog.

If you want to support me for maintaining this blog, REGISTER here for free.Your information is kept confidential.