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...
To my knowledge there's no automatic way to do that. HOWEVER, many people follow the convention of having cells that expect user entry display with a background color that is distinctive. For example, my own practice, even with a spreadsheet I've designed just for my own use, I'll highlight cells where I need to enter or change a value with a yellow background. For example, see the screen image below. The background color can be chosen by you, using the small paint can icon, depicted in this image with a yellow bar under it.