need drop-down arrow in cell

  • Thread starter Thread starter Rogan
  • Start date Start date
R

Rogan

I want to create a spreadsheet for others to update by
adding a row of data and filling in the required
information described by column headings. Some columns
will require a choice from a list of categories while
others are freetext. For the category columns, is it
possible to provide a combo box type list upon clicking on
the appropriate cell that will display the categories and
allow the user to choose one. Upon choosing the category,
the value is entered in the cell. I do not want to draw a
combo-box control in every cell of the sheet and I also do
not want to create in input form for the sheet as users
need to add data directly into the spreadsheet.

Any tips are appreciated
R
 
I want to create a spreadsheet for others to update by
adding a row of data and filling in the required
information described by column headings. Some columns
will require a choice from a list of categories while
others are freetext. For the category columns, is it
possible to provide a combo box type list upon clicking on
the appropriate cell that will display the categories and
allow the user to choose one. Upon choosing the category,
the value is entered in the cell. I do not want to draw a
combo-box control in every cell of the sheet and I also do
not want to create in input form for the sheet as users
need to add data directly into the spreadsheet.
Click to expand...

- Make a list somewhere (maybe on a hidden sheet) and give it a range
name.
- Go to Data -> Validation, and set the values allowed to List, then
specify the range containing your list of category items.
- Ensure that the "In cell drop down" checkbox is checked.
 
Back
Top