ExcelBanter - Data Validation List

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation List (https://www.excelbanter.com/excel-worksheet-functions/166562-data-validation-list.html)

jeggert

Data Validation List

How do I setup the dropdown menu arrow to appear inside the cell at all times?

carlo

Data Validation List

What do you mean by "all times"?

you set it up with Data - Validation - List.
(But i figured you already have that)

if you want to have all cells with this list,
select all cells before entering the list.

Carlo

On Nov 19, 1:54 pm, jeggert wrote:
How do I setup the dropdown menu arrow to appear inside the cell at all times?

Max

Data Validation List

"jeggert" wrote:
How do I setup the dropdown menu arrow to appear inside the cell at all times?

You can't. I'd just format the DV cell to be distinct, eg dark colour
fill/white font, with possibly some text, eg: "Select from DV" in the cell
just above it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

T. Valko

Data Validation List

Use a combo box from the Forms toolbar.

--
Biff
Microsoft Excel MVP

"jeggert" wrote in message
...
How do I setup the dropdown menu arrow to appear inside the cell at all
times?

All times are GMT +1. The time now is 08:20 AM.