I have several columns in a spreadsheet where I would like to use a combo box for data entry into a cell.
I can make the combo box work if I limit the data into a single cell repeatidly, but not when I open a cell in the column and want to use the combo box for the data in that cell.
I am not a VB user, so is there a way using just excel capabilities?

Thanks