drop down list of choices

[claudehollett]

I need (in col E) to offer the user a list of 5 choices for entry. Using a combo box works but I don't want to insert a combo box 10,000 times (this sheet has 10,000 rows). The sheet also looks less than desireable with all those combo boxes. Is there a better way?
Also, my sheet opens for manual entry in col B. After that manual entry code takes me to col E for continued manual entry out to col J. After tabbing out to col J and pressing "enter" Excel takes me back to col E on the next row down. Is there a way to leave col J and be automatically returned to col B on the next row down?

 

[headtoadie]

on the menu try Data->Validation... In the box that pops up choose "List". You can then manually type in the 5 entries or link them.

How this works is, when a user clicks the cell a combo type box appears. When the cell is not selected the box does not appear. Data validation items are copy and pasteable. So after you create it once you can copy and paste it any where you need.

HT