Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

Excel’s Name box is a powerful tool for an ordinary dropdown. To find it, look to the left of the Formula bar. Usually, it displays the reference for the current cell as shown in Figure A .

Using the Name Box. Using the Go To dialog box. Using Hyperlinks. Using VBA Macro. ... In this tutorial, we have explained how to use the command button in Excel. READ: ...