| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list
I had two cells, one right above the other, and each had a drop down list.
Now I want to merge those cells into one cell and have the same drop down list. The arrow, that indicates the drop down, however, keeps appearing towards the top to middle of the merged cell (actually at the bottom of the top cell that is now merged) instead of the bottom of the merged cell, like all the others. How can I move the drop down arrow to have it appear at the bottom of the cell. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
The Dropdown arrow on vertically merged cells will always appear at the top
of the merged range. Nothing can be done AFAIK Gord Dibben MS Excel MVP On Mon, 6 Apr 2009 12:17:01 -0700, Betsy wrote: I had two cells, one right above the other, and each had a drop down list. Now I want to merge those cells into one cell and have the same drop down list. The arrow, that indicates the drop down, however, keeps appearing towards the top to middle of the merged cell (actually at the bottom of the top cell that is now merged) instead of the bottom of the merged cell, like all the others. How can I move the drop down arrow to have it appear at the bottom of the cell. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list
Thank you, Gord. Now I know!
"Gord Dibben" wrote: The Dropdown arrow on vertically merged cells will always appear at the top of the merged range. Nothing can be done AFAIK Gord Dibben MS Excel MVP On Mon, 6 Apr 2009 12:17:01 -0700, Betsy wrote: I had two cells, one right above the other, and each had a drop down list. Now I want to merge those cells into one cell and have the same drop down list. The arrow, that indicates the drop down, however, keeps appearing towards the top to middle of the merged cell (actually at the bottom of the top cell that is now merged) instead of the bottom of the merged cell, like all the others. How can I move the drop down arrow to have it appear at the bottom of the cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
