Pull down menu

  • Thread starter Thread starter fahim
  • Start date Start date
F

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
 
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)
 
Hi
AFAIK there's no such option fur data validation listboxes: You may
consider formating these cells with a different background color.
 
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.
 
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
 
Back
Top