Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Increase width of 'Refers to' box
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Increase width of 'Refers to' box
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 Graeme wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Increase width of 'Refers to' box
Thank you - pressing F2 solves this problem.
"Graeme" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing html code to increase column width does not reflect in ex | Excel Discussion (Misc queries) | |||
Increase column width | Excel Discussion (Misc queries) | |||
ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
Increase width of chart column | Excel Discussion (Misc queries) | |||
increase column width in PowerPoint chart | Excel Discussion (Misc queries) |