Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lee
 
Posts: n/a
Default Validation drop-down lists

How do I increase the default length of a validation drop-down list to more
than 8 lines? For example, to 12 for the months of the year.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Validation drop-down lists

No, you can't change the number of items in the dropdown list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Lee" wrote in message
...
How do I increase the default length of a validation drop-down
list to more
than 8 lines? For example, to 12 for the months of the year.



Reply
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
change font to validation drop lists rfigueroa Excel Worksheet Functions 2 January 2nd 06 11:33 PM
Font size in data validation drop down lists Ryan Excel Discussion (Misc queries) 2 December 11th 05 05:52 PM
data validation - Drop Down Lists Annie Excel Discussion (Misc queries) 8 July 29th 05 01:03 AM
Data Validation - Drop down lists - if then? Steve R Excel Discussion (Misc queries) 2 April 8th 05 06:13 PM
Change font size in drop down validation lists Big Daddy Excel Discussion (Misc queries) 2 February 3rd 05 05:22 PM


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

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

About Us

"It's about Microsoft Excel"