View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cbh35711
 
Posts: n/a
Default Name Drop-Down Box


I've got a 50 sheet excel document and i want to create names to get me
to A1 on every page, so I don't have to scroll left and right all the
time.
So, here's my problem.
I would like to increase the number of names shown when i click the
drop down box. Right now it shows 7, in Office 2003. I would love to
increase that to show 50, or else I’m not really getting the
functionality I’m looking for.
I think this will take some kind of registry tweak.
Does anyone know how/where I can?

Thanks in advance,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=501801