Forum Discussion
How to graphically show that a cell is a drop down list
Hi, I have created a calculation tool for my colleagues and I need to show that a cell containing a dropdown list "is" a drop down list. Currently the cell only indicates it is a drop down list if on...
Thanks to you all for your advice.
This is what I did based on your advice - I changed the outline of the cell to a double line, changed the fill colour and wrote "select from drop down list above" below the cell. I'm still curious as to why excel doesn't turn a drop-down list cell show that it is a drop-down cell without clicking on it.
This is what I did based on your advice - I changed the outline of the cell to a double line, changed the fill colour and wrote "select from drop down list above" below the cell. I'm still curious as to why excel doesn't turn a drop-down list cell show that it is a drop-down cell without clicking on it.