UNIT 3—INTRODUCTORY MICROSOFT EXCEL

By using the Data Validation feature in Excel, you can limit cell entries to acceptable data. STEPS. Select the cells where you want to apply data validation. On the DATA menu, click VALIDATION, and then click the SETTINGS tab. In the ALLOW box, click the type of data. To specify only numbers, click WHOLE NUMBER or DECIMAL. ................
................