Data validation
- This topic is empty.
-
Posts
-
How to active ‘Data validation’ tool in xls.2007? please guide me.
Actually what you want to do by active ‘Data validation’ tool, please clarify, we must help you.
TO
TORKONA,
I INFORM YOU THAT STEP BY STEP
FIRST I OPEN EXCEL 2007(SHEET1)>SELECT A COLM(‘E’)>DATA >DATA VALIDATION> THEN I SEE THREE OPTION LIKE AS i)data validation ii)circule validation iii)clear circle validation .but no 1(data validation) option is in active.so how to active it.pls suggest me.See the steps-
please share the function of “circle invalid data” & “clear invalidation circles”.
Let us consider a cell B2 where data validation in puts are a, b, c. Now if you put ‘k’ in the cell B2 then a message box will come “The value entered is not valid”, but if you off the ‘error alert’ option in data validation box, then the cell take the value ‘k’ without any notice. In that case for searching invalid data in the entire sheet- first you select whole sheet and then click ‘circle invalid data’ the cells containing in valid data (in this case the cell B2) appearing with a red circle. For removed the circles, again select the selected cells and click ‘clear invalidation circles’ the red circles will disappear.
- You must be logged in to reply to this topic.