Width of Active Cell Name drop down combo list


J

John Google

Is there any way to make the width of the drop down combo box wider in
Excel XP.

The one I'm referring to is the one in the top left (to the left of
the formula bar) which shows the active cell name.

I tend to use long names for my named ranges so, when I click the drop
down arrow, it only shows the first part of the name. Ideally, I would
like it twice as wide.

John.
 
Ad

Advertisements

R

Rick Rothstein \(MVP - VB\)

It doesn't look like you can change its size; however, you can get a longer
field to work with by clicking Insert/Name/Define on Excel's menu bar.

Rick
 
R

Rick Rothstein \(MVP - VB\)

If you think this "solution" will work for you, you can save yourself one
menu item click and a little searching for the Name item by adding a button
to the toolbar giving you direct access to Name sub-menu. Right click the
toolbar and select Customize from the popup menu that appears; select the
Commands tab; click on Built-in Menus in the Categories list box; then
select Name from the Commands list box; drag that entry onto one of your
toolbars and drop it there; close the dialog box. You can now click the Name
button and immediately select Define from its drop-down menu.

Rick
 
G

Gord Dibben

John

Some options to explore ..

1. Try Chip's:
http://www.cpearson.com/excel/NameBox.htm

2. From a Tom Ogilvy posting:

Robert Gelb wrote a program that allows you to resize
the namebox itself.

http://www.vbrad.com/pf.asp?p=Source/src_excel_namebox.htm
(Two versions--one for xl97 and one for xl2k and above.)

3. From a JKP posting:

If you use defined names a lot, consider downloading the Name manager (by
Jan Karel Pieterse, Charles Williams & Matthew Henson) from:

www.bmsltd.co.uk/mvp


Gord Dibben MS Excel MVP
 
Ad

Advertisements

G

Gord Dibben

Thanks Rick

Going to the URL I posted one does get a "click here" link.

I'll try to remember to update.

Don't get much call for that particular page.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top