When you enter longer text than will fit in a normal Excel cell, the excess text either carries over into the next blank cell or is truncated by adjacent data. You have several options to remedy this.

Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box. Combo boxes provide you with a list of choices ...