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.

Excel also displays the cell reference in the "Name Box," which is a text box that displays ... and you can restore these labels to find hidden cell references as needed. Launch Excel and click ...

Microsoft Excel's alternative to this time-saving tool is somewhat unimaginatively called "names," accessed through the name box in the top-left corner of your workbook. Let's say you have a huge ...