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

Advertisements

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
 
Ad

Advertisements

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
 

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

Top