Expand default size of Define Name dialog box

batman37

New Member
Joined
Jul 21, 2007
Messages
10
I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up showing 25 ranges? Perhaps a setting in the Registry. Or is the 10-row default hard-coded?

Thanks for any solution or words of wisdom.
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
7,768
Office Version
2016
Platform
Windows
I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up showing 25 ranges? Perhaps a setting in the Registry. Or is the 10-row default hard-coded?

Thanks for any solution or words of wisdom.
You can easily resize the Define Name dialog to full screen just by double-clickng its titlebar.
 

batman37

New Member
Joined
Jul 21, 2007
Messages
10
Thanks, Jaafar.
I was not aware of that feature, which presumably applies to any and all dialog boxes. That said, I would much rather be able to see my worksheet while the Define Name dialog box is up; thus my interest in extending its vertical height without making it any wider. Yes, I can drag the bottom down, and I often do that. But I would much rather have the bottom much lower by default. Is there a way to do that?
 

Jaafar Tribak

Well-known Member
Joined
Dec 5, 2002
Messages
7,768
Office Version
2016
Platform
Windows
AFAIK, there is no way to set the default height .

I honestly don't see why one would want to do this when it is so easy to drag the dialog bottom down with a simple mouse gesture.

One could set the height via some complicated api code but frankly, I don't think it would be worth the effort.

Regards.

Regards.
 
Last edited:

batman37

New Member
Joined
Jul 21, 2007
Messages
10
Well, you're welcome to your opinion. That said, I did a Registry search on "Define Name" - it came up empty, so I have no choice to accept that what I would like to do can't be done. It's not a show stopper. Thanks for your responses.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,481
Messages
5,444,739
Members
405,299
Latest member
rcurtin

This Week's Hot Topics

Top