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

Usability - drop down box - Arrow INSIDE box? 1
Data Validation Drop Down Menu Width 1
Blank Rows from Merged Cells in Drop Down Menu 1
List the Drop down list from the top 3
list in one cell 2
Help with validation functions 1
In-Cell Drop Downs not visible 2
drop downs showing down arrow 4

Top