Width of drop-down list in Excel cell. 2

[Ed2020]

Hi,

I'm sure this is a really simple thing to do:

I have a cell with data validations set as limited to a list. Some of the entries in the list are quite long, however I want the cell to be narrow (and only display the first character of the selection.

When the user presses the arrow to display the list of allowable entries the width of the displayed list appears to limited to the width of the cell + width of the arrow.

Is there any way of increasing the width of the list, without increasing the width of the cell?

Hope I've explained this clearly enough!

Many thanks,

Ed Metcalfe.

Please do not feed the trolls.....

 

[GlennUK]

It's not that simple a thing to do, but Debra Dalgleish explains how you could do it here:

http://www.contextures.com/xlDataVal08.html#Wider

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Gavona]

That will be really useful - thanks Glen.

Gavin

 

[Ed2020]

Hi Glenn,

Apologies for the delay in replying, and thanks for the link.

Have a purple star.

Ed Metcalfe.

Please do not feed the trolls.....