How do you make the Named Ranges box bigger in Excel?

Question

The box with the Named ranges in it is too small to see the whole name sometimes, so I have to open the Insert Name dialog. How do I increase the width of the Named Range box (I don't mind shrinking the formula box)?

score 4 · Accepted Answer · answered Aug 09 '10 at 21:01

4

In 2003 you can do it with a macro like this.

answered Aug 09 '10 at 21:01

Jarvin

7,236
6
50
63

WOW, did that work great. – Lance Roberts Aug 10 '10 at 23:27
@Lance Roberts, Thank you. That's very handy. – Brian Hooper Jan 10 '11 at 14:52

How do you make the Named Ranges box bigger in Excel?

1 Answers1