drop down list

B

Betsy

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.
 
G

Gord Dibben

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
 
B

Betsy

Thank you, Gord. Now I know!



Gord Dibben said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Paragraph numbering in Word 1
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Move Drop Down List to the Top of the Cell 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Print Macro w/drop down list 1

Top