LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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知 not really getting the
functionality I知 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down box leading to another drop down box stumakker Excel Discussion (Misc queries) 2 January 12th 06 05:03 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
advanced: synchronizing data value across two worksheet drop boxes mdhokie Excel Worksheet Functions 1 October 6th 05 08:46 PM
formulas for drop down menus Char Excel Discussion (Misc queries) 0 July 18th 05 07:29 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM


All times are GMT +1. The time now is 01:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ゥ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"