| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Drop Down Boxes for Validation Cells are Too Wide
For some reason, in some columns of my spreadsheet the validation drop
down boxes are too wide for the cell. In column A, for example, they will be the width of the cell plus the dropdown arrow - perfect. In column C they will exceed the width of the cell plus the drop down arrow. How do I fix this? |
|
#2
|
|||
|
|||
|
Extra wide dropdown lists appear occasionally, usually if cells on the
worksheet have been merged (not necessarily the cell with the data validation). To get rid of them, you may have to delete the row or column and recreate the data validation. Geoff wrote: For some reason, in some columns of my spreadsheet the validation drop down boxes are too wide for the cell. In column A, for example, they will be the width of the cell plus the dropdown arrow - perfect. In column C they will exceed the width of the cell plus the drop down arrow. How do I fix this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using symbols for drop down list boxes? | Excel Worksheet Functions | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
| Dynamic Drop Down Boxes | Excel Worksheet Functions | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| how do you create drop down menus for individual cells in excel? | Excel Worksheet Functions | |||
Linear Mode
