Select Data Validation from the Data Tools group on the Data tab.
Select List in the Allow box on the Settings tab.
Type your list values in the Source field, separated by commas.
Make sure the In-cell dropdown check box is turned on.
Determine data sample. Determine the data to sample.
Check the database for errors. Before you relocate your data, make sure you have all of the necessary information in your current database.
Check the data format.
During entering, select the cell or cells you want to inspect. Click Data Validation in the Data Tools category on the Data tab to launch the Data Validation dialogue box.
Choose one or more cells to verify.
The Data Validation dialogue box appears.
Select Custom in the Allow box of the Data Validation dialogue window's Settings tab, then type your data validation formula in the Formula box.
Click OK.
Click the arrow next to Data Validation on the Data tab, then Circle Invalid Data in the Data Tools group. Any cells with improper data are marked with a red circle in Excel.
Learner's Ratings
4.7
Overall Rating
84%
9%
5%
2%
0%
Reviews
M
MRIDHA MD MERAJ
5
Very good and Thank you so much
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.