Check Data Entry in Excel

This article examines Data and explains the main developments, practical implications, and context readers should understand.

Data Overview

To enter the test conditions for this region, do the following: Go to Sheet2 à Select area A1: A10 and Select Data and Data Validation. On the Settings tab, Validation Criteria select Allow: List, Source enter = Mahang, check the Ignore Blank box if you want to ignore the empty boxes, In-cell dropdown box if you want a drop-down list box. Switch to the Input Messsage tab, enter the instructions, select Show input. If you want the instructions to appear when the cell is selected. Switching to the Error Alert tab enter the warning information when it is entered incorrectly, select Show error. If you want to show the warning information. Click OK.

Now when entering data in Sheet2! A1: A10 area, a Dropdown List box appears and almost certainly you don't have a chance to enter the wrong code!

In addition, you can refer to other advanced data entry techniques at the following websites: - English: www. Contextures. Com/tiptech. HTML, download the example file www. Contextures. Com/DataValSample. Zip - Vietnamese: www. Webketoan. Com, www. Giaiphapexcel. Com (http://www. Giaiphapexcel. Com/forum/showthread. Php? T=98&highlight=Data+Validation). Nguyen Trong Thanh Email: ng. Tr. Thanh@Gmail. Com; ntthanhhp@vnn. Vn