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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,924
Members
448,533
Latest member
thietbibeboiwasaco

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
Back
Top