Increase width of 'Refers to' box

G

Graeme

I have a few Defined Names in a file, and need to edit the formula in the
Refers to box. However, the formulae is too long for all of it to be visible
in the box. And when I try and use the arrows on my keyboard, it starts to
add unwanted cell references to the formula. Is there a way of widening the
size of the Refers to box or maybe just an easier way to navigate to the end
of the formula? Thanks.
 
D

Dave Peterson

You can't widen the Insert|Name dialog (well, in xl2003 and earlier), but you
can hit F2 instead.

F2 toggles between Point, Edit, Enter mode.
(watch the statusbar and you'll see an indicator)

Since you're working with names, you may want to try Jan Karel Pieterse's (with
Charles Williams and Matthew
Henson) Name Manager:
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp
 

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

Similar Threads

Name - Refers to - what does the ! represent? 1
Print a list of defined names and what it refers to 5
editing 'refers to'" box in naming dynamic ranges 5
Combo Box - Field Width 1
'Name box'--increase width 1
Help with defining names 3
How to move around in the "refers to" box? 2
Increase Check Box Size 4

Top