Align Combo Box in Excel

[modmac]

I have a worksheet that has approx. 20 Combo boxes, The boxes are in the same column one below the other and approx the same size. The question is how can I have all of them either snap to the cell behind them or get them the same size.

 

[glg1]

Hi Modman,
Here's how to align.
Make sure you have the drawing tool bar at the bottom open.
Select all the boxes you want aligned. Go into draw>align or distribute> align left. They should all snap into alignment.

Hope this helps.
George

 

[SkipVought]

modmac,

Have you tried using Data/Verification - List - In-cell drop down?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]