Extend the Name Box

Excel 2007 only

By Neale Blackwood
New in Excel 2007, you can change the width of the Name Box to allow you to display long range names. If you point to the right of the drop down arrow in the Name Box you will see a double-headed arrow that you can click, hold and drag left or right to change the width of the Name Box. This allows you to use longer, more meaningful names and still be able to see the whole name.