Number of items listed in Name Box

Number of items listed in Name Box - Excel 2002.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vega953@gmail.com - 17 Jan 2008 11:02 GMT

Hi All,
Does anybody know how you can increase the number of items that show
in the drop down Name Box Field. Currently there are 7, but I am sure
I have had it set up with more in the past. Thank you for any
suggestions.
K.

Reply to this Message

Jim Rech - 17 Jan 2008 13:34 GMT

I haven't seen a way to increase the number of items displayed at a given
time in the name box drop down. It was increased to 30 from 7 in Excel
2003.

Signature

Jim

Reply to this Message

Charles Williams - 17 Jan 2008 15:09 GMT

An alternative would be to use Name Manager (by Charles Williams and JK
Pieterse):
download from http://www.DecisionModels.com/downloads.htm

Charles
_________________________________________
FastExcel 2.3
Name Manager 4.0
http://www.DecisionModels.com

>I haven't seen a way to increase the number of items displayed at a given
> time in the name box drop down. It was increased to 30 from 7 in Excel
[quoted text clipped - 6 lines]
> | suggestions.
> | K.

Reply to this Message

vega953@gmail.com - 17 Jan 2008 23:12 GMT

> I haven't seen a way to increase the number of items displayed at a given
> time in the name box drop down. It was increased to 30 from 7 in Excel
[quoted text clipped - 10 lines]
> | suggestions.
> | K.

Thanks for the info. K.

Reply to this Message