Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

editing 'refers to'" box in naming dynamic ranges

0 views
Skip to first unread message

R.VENKATARAMAN

unread,
Feb 12, 2004, 4:11:07 AM2/12/04
to
When naming dynamic ranges of Tushar Mehta and others I find that the
"refers to" box is overflowing and I am not able to maximize the box and see
the full entries. . I also find some problem in editing the entries in this
box bcause the entries get messed up if I use the arrows keys . I tried to
get some reference through "google search" bar in excel. Perhaps my entry in
the subject box of this google search form may not be correct. Can somebody
show me the way to the relevant references or give me solution for the
problem. .
thanks and regards.


Debra Dalgleish

unread,
Feb 12, 2004, 7:01:29 AM2/12/04
to
You can't change the size of the entry box, but to use the arrow keys,
press the F2 key on the keyboard


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

xlbo

unread,
Feb 12, 2004, 6:01:06 AM2/12/04
to
Unfortunately, I don't think you can change the size of the names box. As to usage of arrow keys, you just can't - you have to use the mouse to position teh cursor in the right place and use delete / backspace etc and then type your changes

Rgds
Geoff

Charles Williams

unread,
Feb 12, 2004, 12:10:01 PM2/12/04
to
You might want to look at the Name Manager I developed with Jan Karel
Pieterse.
It will handle both very long names and very long refersto
(and a lot more besides!)

download from
http://www.DecisionModels.com/Downloads.htm

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Debra Dalgleish" <d...@contexturesXSPAM.com> wrote in message
news:402B6B19...@contexturesXSPAM.com...

Gord Dibben

unread,
Feb 12, 2004, 1:10:35 PM2/12/04
to
Adding to Debra's reply, if you see "point" down on status bar, you can't use
the arrow keys.

When you hit F2, you will see "Edit" on the status bar. Now you can use the
arrow keys.

Just a visual reminder of which mode you are in before you start navigating in
the "refers to" box.

Gord Dibben Excel MVP

On Thu, 12 Feb 2004 07:01:29 -0500, Debra Dalgleish <d...@contexturesXSPAM.com>
wrote:

R.VENKATARAMAN

unread,
Feb 12, 2004, 11:22:50 PM2/12/04
to
Thanks all of you, particularly MS Debra Dalgleish's suggestion of using F2.
I shall browse Mr. williams' name manager.


Charles Williams <Cha...@DecisionModels.com> wrote in message
news:uza10pY8...@TK2MSFTNGP11.phx.gbl...

0 new messages