| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to select group of drop down lists to align
I have 10 rows which have drop down selection boxes in each row - these have
become out of alignment since I have inserted some more. How do I select all the drop down boxes (Group?) so I can then align them all and make them the save size. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to select group of drop down lists to align
On the Drawing toolbar, click on the Select Objects button, to activate that
tool. With the tool, draw a rectangle around the dropdowns, to select them all. On the Drawing toolbar, click the Draw button, and choose Align or DistributeAlign Left. Click the worksheet, to deselect the dropdowns Click the Select Objects button, to deactivate the tool. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html "HelenMB" wrote: I have 10 rows which have drop down selection boxes in each row - these have become out of alignment since I have inserted some more. How do I select all the drop down boxes (Group?) so I can then align them all and make them the save size. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple drop down lists | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Can different drop down lists be displayed depending on the value. | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| How do I change the appearance of my drop down lists? | Excel Worksheet Functions | |||
Linear Mode
