jagdish

by jagdish
(rayagada)

Excel-2007

Excel-2007

what is use of data validation in Exce-2007? and how it works?

Comments for jagdish

Average Rating starstarstarstarstar

Click here to add your own comments

Mar 25, 2014
Rating
starstarstarstarstar
Data Validation
by: Anonymous

Data validation in Excel is used to control the content that is entered into a cell. Click on a cell then click on the data validation button. This will open a window for you to set your criteria. The drop down menu in the allow section has a variety of options. When you select one of these options it will only allow that type of data to be entered into that cell. Next click on the input message tab. This tab will let you enter a message to the spreadsheet user when wrong data is entered into the cell. For example if you only want a time entered in the cell and a whole number is entered you can give them a custom message stating that it is not valid to enter that number and please enter a time.

I hope this helps. Please ask if you need more assistance.

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Share your computer tips or ask a question.