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.6
Overall Rating
81%
11%
6%
2%
0%
Reviews
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.