| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop down list
I have a new worksheet setup however, excel will only allow me to enter so much sata in the drop down validation list. I need at least tripple the amount that is allowed any way of doing this. I even tried putting the list in Open office and that al worked fine then tried to open it in Excel but excel just deleted the bottom of the list Any suggestions -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#2
|
|||
|
|||
|
Hi!
A data validation drop down list can have 32,767 entries. Biff "timboellis" wrote in message ... I have a new worksheet setup however, excel will only allow me to enter so much sata in the drop down validation list. I need at least tripple the amount that is allowed any way of doing this. I even tried putting the list in Open office and that al worked fine then tried to open it in Excel but excel just deleted the bottom of the list Any suggestions -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#3
|
|||
|
|||
|
Well i am doing less than that and it will not let me do it. -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#4
|
|||
|
|||
|
Just compliing the whole list. So you can see exactly what i am trying to enter -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#5
|
|||
|
|||
|
This is the list CFS CAST25 CAST5 CHEST CLASBOX CLAS5 CLASTWN CLAS25 CLAS50 KEC5 KEC25 KEC50 KECRO5 KEDIA10 PAN6 PAN30 PAN60 SCLASF5 SCLASF10 CLIP CONMA CONTU CONTOB FTRTIP TOKAI CHEST20 DAVCL20 DAVG20 EMB10 EMB20 EMBBL10 EMBBL20 EFT10 EFT20 JPS10 JPS20 JPSW20 LB10 LB20 LBM20 LBG10 LBG20 LBW20 MARL10 MARL20 MARLG10 MARLG20 MARLM20 MARLMED20 MAXSK20 MAXSKG20 NAVYCUT20 RAF20 RAFW20 REGFT10 REGFT20 RKS10 RKS20 RICH10 RICH20 RICHS10 RICHS20 RICHM20 RICHSK10 RICHSK20 RICHSKS10 RICHSKS20 RICHSKM10 RICHSKM20 SKS10 SKS20 SKSB10 SKSB20 SKSM20 SKSW20 WBINE DRM12.5 DRM25 DRM50 DRMG12.5 DRMG25 GV12.5 GV25 GV50 GBL25 GBL50 STBRUFL25 STBRUFL50 STBRURR25 STBRURR50 JOB RIZRD RIZGRN RIZBLU RIZSLV RIZW RIZKSR RIZKSB RIZKSSB RIZKSG RIZKSSIL RIZLIQ -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#6
|
|||
|
|||
|
Hi!
In the grand scheme of things, that's not a very long list! How EXACTLY are you setting up your drop down? What version of Excel are you using? If I remember correctly some "early" versions have a problem (bug) when using drop downs AND the sheet has FROZEN PANES or a WINDOW SPLIT. Biff "timboellis" wrote in message ... This is the list CFS CAST25 CAST5 CHEST CLASBOX CLAS5 CLASTWN CLAS25 CLAS50 KEC5 KEC25 KEC50 KECRO5 KEDIA10 PAN6 PAN30 PAN60 SCLASF5 SCLASF10 CLIP CONMA CONTU CONTOB FTRTIP TOKAI CHEST20 DAVCL20 DAVG20 EMB10 EMB20 EMBBL10 EMBBL20 EFT10 EFT20 JPS10 JPS20 JPSW20 LB10 LB20 LBM20 LBG10 LBG20 LBW20 MARL10 MARL20 MARLG10 MARLG20 MARLM20 MARLMED20 MAXSK20 MAXSKG20 NAVYCUT20 RAF20 RAFW20 REGFT10 REGFT20 RKS10 RKS20 RICH10 RICH20 RICHS10 RICHS20 RICHM20 RICHSK10 RICHSK20 RICHSKS10 RICHSKS20 RICHSKM10 RICHSKM20 SKS10 SKS20 SKSB10 SKSB20 SKSM20 SKSW20 WBINE DRM12.5 DRM25 DRM50 DRMG12.5 DRMG25 GV12.5 GV25 GV50 GBL25 GBL50 STBRUFL25 STBRUFL50 STBRURR25 STBRURR50 JOB RIZRD RIZGRN RIZBLU RIZSLV RIZW RIZKSR RIZKSB RIZKSSB RIZKSG RIZKSSIL RIZLIQ -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
|
#7
|
|||
|
|||
|
Hi thanks for your replies I was just being this , I put a list in one colum then selected this list to go into the validation and then hid the colum and all works fine now cheers -- timboellis ------------------------------------------------------------------------ timboellis's Profile: http://www.excelforum.com/member.php...o&userid=25381 View this thread: http://www.excelforum.com/showthread...hreadid=396870 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down List problems | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Linear Mode
