Data Validation Di Excel 2007. In microsoft excel 2007 2010 2013 2016 2019 and 365 the data validation command is moved into data tools group under data tab. Click the data tab.
For an example i. Tutorial created by excel tutor. Here you set what you want like any value whole number and etc.
Now go to data tab and select data validation.
Then you will view the data validation button. How can i use data validation in excel 2007. After select whole number you see some boxes come one. Tutorial created by excel tutor.