Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make the Name Box wider?
In Excel 2000, is there any way to make the "Name Box" wider?
I use a lot of long range names for referencing in formulae, so that the names are more self-explanatory than cryptic. The "Name Box" is on the same line/toolbar and to the left of the "Formula Bar" in the default user configuration. The mousepointer icon used to adjust a vertical boundary doesn't seem to pop up when the mouse pointer is brought over it. Any optional trick to be able to read a long range name assigned to a cell? Can I move the Name Box to somewhere else where there is more room? The "regular" toolbar space is two lines high and has a whole lot of empty space. Thanks, Fred Holmes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make the Name Box wider?
Check out this link at the verry bottom of the page under Miscellany...
http://www.xldynamic.com/source/xld.Names.html -- HTH... Jim Thomlinson "Fred Holmes" wrote: In Excel 2000, is there any way to make the "Name Box" wider? I use a lot of long range names for referencing in formulae, so that the names are more self-explanatory than cryptic. The "Name Box" is on the same line/toolbar and to the left of the "Formula Bar" in the default user configuration. The mousepointer icon used to adjust a vertical boundary doesn't seem to pop up when the mouse pointer is brought over it. Any optional trick to be able to read a long range name assigned to a cell? Can I move the Name Box to somewhere else where there is more room? The "regular" toolbar space is two lines high and has a whole lot of empty space. Thanks, Fred Holmes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make the Name Box wider?
Marvelous, many thanks for the solution.
Fred Holmes -- So simple I should have been able to figure it out for myself! <g On Mon, 1 Jun 2009 08:00:02 -0700, Jim Thomlinson wrote: Check out this link at the verry bottom of the page under Miscellany... http://www.xldynamic.com/source/xld.Names.html -- HTH... Jim Thomlinson "Fred Holmes" wrote: In Excel 2000, is there any way to make the "Name Box" wider? I use a lot of long range names for referencing in formulae, so that the names are more self-explanatory than cryptic. The "Name Box" is on the same line/toolbar and to the left of the "Formula Bar" in the default user configuration. The mousepointer icon used to adjust a vertical boundary doesn't seem to pop up when the mouse pointer is brought over it. Any optional trick to be able to read a long range name assigned to a cell? Can I move the Name Box to somewhere else where there is more room? The "regular" toolbar space is two lines high and has a whole lot of empty space. Thanks, Fred Holmes |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make the Name Box wider?
Almost intuitive once you have seen the answer...
-- HTH... Jim Thomlinson "Fred Holmes" wrote: Marvelous, many thanks for the solution. Fred Holmes -- So simple I should have been able to figure it out for myself! <g On Mon, 1 Jun 2009 08:00:02 -0700, Jim Thomlinson wrote: Check out this link at the verry bottom of the page under Miscellany... http://www.xldynamic.com/source/xld.Names.html -- HTH... Jim Thomlinson "Fred Holmes" wrote: In Excel 2000, is there any way to make the "Name Box" wider? I use a lot of long range names for referencing in formulae, so that the names are more self-explanatory than cryptic. The "Name Box" is on the same line/toolbar and to the left of the "Formula Bar" in the default user configuration. The mousepointer icon used to adjust a vertical boundary doesn't seem to pop up when the mouse pointer is brought over it. Any optional trick to be able to read a long range name assigned to a cell? Can I move the Name Box to somewhere else where there is more room? The "regular" toolbar space is two lines high and has a whole lot of empty space. Thanks, Fred Holmes |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make the Name Box wider?
The provided code is marvelous, but it seems to widen only the
drop-down list of the Name Box -- which is a big help, but: I'd really like to widen the always-visible text box of the Name Box, either by moving it to some "unused" portion of the tool bars, or even by just shortening the Formula Bar. That would be really convenient. So I can see the full string of the name as I am typing it in, or so I can see the full string of the name of the current active cell with only having to look at the Name Box. I hope I'm in luck in finding some help. Maybe they provided this in later versions of Excel? Fred Holmes On Mon, 1 Jun 2009 08:00:02 -0700, Jim Thomlinson wrote: Check out this link at the verry bottom of the page under Miscellany... http://www.xldynamic.com/source/xld.Names.html -- HTH... Jim Thomlinson "Fred Holmes" wrote: In Excel 2000, is there any way to make the "Name Box" wider? I use a lot of long range names for referencing in formulae, so that the names are more self-explanatory than cryptic. The "Name Box" is on the same line/toolbar and to the left of the "Formula Bar" in the default user configuration. The mousepointer icon used to adjust a vertical boundary doesn't seem to pop up when the mouse pointer is brought over it. Any optional trick to be able to read a long range name assigned to a cell? Can I move the Name Box to somewhere else where there is more room? The "regular" toolbar space is two lines high and has a whole lot of empty space. Thanks, Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do a make a column wider than the screen? | Excel Discussion (Misc queries) | |||
Make Validation List Wider - Excel 2003 | Excel Discussion (Misc queries) | |||
How do I make the drop-down portion of a list wider than the cell? | Excel Discussion (Misc queries) | |||
Help with Macro - Make Dropdown List Temporarily Wider | Excel Discussion (Misc queries) | |||
How to make fx field wider? | Excel Discussion (Misc queries) |