Thread: Drop Boxes

Is there a way to make a cell a drop box? So that when it is clicked on, a list of options drops down to click on?
How can that be done offline?

Thanks,
Kyle P.

Originally Posted by Andy Pope

Sounds like you are describing Data Validation using a list.

Not sure what you mean by offline though.

Thanks Andy,
I say offline because I'm used to seeing this function on websites. I'd actually like to use a drop box here to build a job quoting tool at the solar company I work for. Right now, I have to type in each individual panel for their price per watt to show up in another cell where it's factored into the computations.
There are so many panels now, I'm the only one who know all the abbreviations for the cells to recognize which panel I'm talking about!
I'd like other employees to be able to click on the "Panel Selection' cell and pick from a list of panels.

Thanks Again for any Help,
Kyle P.