EXCEL Restricting Cell Input Data Gwinnett Couny Public SchoolsExcel限制细胞输入数据格威纳特县公立学校.ppt

A few tricks to take you beyond the basics of Microsoft Office Microsoft Excel: Restricting Cell Input Data. Some of the Excel worksheets you create will be shared by other people... perhaps even used to gather responses from them. You can specify certain cells where others will enter the data you are seeking. EXCEL: Restricting Cell Input Data And you can set up your answer cells so that the data others might enter will be exactly the kind you need and in the format you want. EXCEL: Restricting Cell Input Data Controlling entries in this way is referred to as “data validation” which means you can set up Excel to reject any data that someone might try to enter in a form you don’t want. EXCEL: Restricting Cell Input Data For example, if an answer going into the cell is not supposed to exceed a certain dollar amount, you can set it to reject any entry above that amount. EXCEL: Restricting Cell Input Data Or... suppose you want entries to be only in text... no numerals... you can set it up just that way. EXCEL: Restricting Cell Input Data Or... suppose the entries have to be within a certain range of numbers... you can set it up that way. That could be helpful if you are searching for respondents in a specific age range... or who have a certain grade point average. EXCEL: Restricting Cell Input Data Here are the easy steps required to restrict the kind of data that can be entered into a cell. First, select the cell or cells you want to work on. EXCEL: Restricting Cell Input Data Go up to the top of your Excel screen and click on “Data.” EXCEL: Restricting Cell Input Data That will drop down a list of options. EXCEL: Restricting Cell Input Data Click the option called “Validation.” EXCEL: Restricting Cell Input Data That will open up a box called “Data Validation.” EXCEL: Restricting Cell Input Data The default type of data allowed is “Any value”... EXCEL: Restricting Cell Input Data but you can click on this little pointer to