Pull down menu

[fahim]

I am using data validation in excel. I would like the user of my
worksheet to know which cells have pull down menus associated with
them rather then making them go and select each cell individually to
find out whether or not it consists of a pull down menu. Is there a
way of having the pull down arrow remain on the spreadsheet regardless
of whether or not the cell has been selected.

Thanks,
Fahim

 

[Bob Phillips]

No, there isn't AFAIK.

Why don't you just colour the cells?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
AFAIK there's no such option fur data validation listboxes: You may
consider formating these cells with a different background color.

 

[Frank Kabel]

No, there isn't AFAIK.

Why don't you just colour the cells?

Hi Bob
two people with the same idea
just posted my answer before I saw yours

Frank

 

[Bob Phillips]

Hi Frank,

Serendipity, or great minds?

Bob

Hi Bob
two people with the same idea
just posted my answer before I saw yours

Frank

 

[Frank Kabel]

Hi Frank,

Serendipity, or great minds?

Bob

Hi Bob

using adjectives like 'serendipity' is not fair for a non-native
speaker -> http://dict.leo.org
After getting the translation: the latter one, of course <vbg>

Frank

 

[Ken Wright]

Aftre the fact, but you can also try Edit / Go To / Special / Validation. Also
have the option to choose all validation or same as current cell.

 

[Debra Dalgleish]

The arrow is only visible in the active cell.
You could insert a comment in each cell, and leave the comment indicator
visible. It appears as a red triangle at the top right of the cell, but
does not print.

Insert a comment in one cell (Insert>Comment)
Select that cell, and choose Edit>Copy
Select the remaining cells with Data Validation
(drag to select a group of contiguous cells, or
hold the Ctrl key and click on noncontiguous cells)
Choose Edit>Paste Special
Select Comment, click OK