Drop down lists and amount of characters shown within it

rmtaylor

Board Regular
Joined
Feb 17, 2002
Messages
155
Hi


Drop down lists and amount of characters shown within the list when it is activated.
I’m sure this must be a common problem.

I have searched the FAQ but could not find any info relating to my problem.

Example
I have a validated a dropdown to activate in say a1 to a5

The list of information used to populate this is located d1:d15

Typical contents of the list in d1 to d15 are 30 characters long including spaces.

It is desirable that column a is only set to 10 points wide .

When any cell from a1 to a5 is selected only part of the items description (12 characters approx.) is shown within the drop down.

Is it possible to change this so that the full length of the text can be read, without just increasing the column width to accommodate it.


(my company only has office 97)

Any help or soultion will be appreciated
Regards
Robert
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

rmtaylor

Board Regular
Joined
Feb 17, 2002
Messages
155
Many thanks for your reply, I found the information very user friendly and valuable.
I have used the code within my sheet & it is works a treat.


Regards
Robert
 

rmtaylor

Board Regular
Joined
Feb 17, 2002
Messages
155
Many thanks for your reply Krishnakumar, I found the information very user friendly and valuable.
I have used the code within my sheet & it is works a treat.


Regards
Robert
 

Forum statistics

Threads
1,136,305
Messages
5,674,984
Members
419,540
Latest member
Nereus A

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top