At 11:19 28/01/2015 -0500, Vince Bonly wrote:
Can someone point me to info on creating a dropdown menu in a
Spreadsheet cell, if this is possible? I have created a spreadsheet
to calculate Heating Fuel consumption, and frequently need to enter
a specific date into a cell. A dropdown menu, I think, would save me
time when needing to do this.
o Enter the suggested values into cells somewhere in the spreadsheet.
(These can be tucked away somewhere.)
o Potentially select this cell range and use Insert | Names > |
Define... to give the list a name.
o Select the target cell or cell range.
o Go to Data | Validity... .
o On the Criteria tab, for Allow, select Cell Range.
o Click in the Source box and either drag over the list or type its name.
There are many options you can adjust, such as "Show selection list"
(which you will want), as well as "Allow blank cells", and providing
some help text when the target cell is selected. The Error Alert tab
allows you to control whether values not in the list are permitted
(Warning instead of Stop) and an error message that can be produced.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
