for example you have 100 question in Column A (Question Range: A1: A100) and the user answers in B column for each one (Answer Range: B1: B100).
Data Validation Those that have used Data Validation will know that it is a very handy feature, especially the List option.
Instant Download and Money Back Guarantee on Most Software Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software! Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To......
You can use data validation to restrict the type of data or the values that users enter into a cell.
Note: The following examples use the Custom option where you write formulas to set your conditions.