Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating
what is purpose of validating in particular range?how we can validated some
selected cells? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating
Take a look he
http://contextures.com/xlDataVal01.html In article , Ayesha wrote: what is purpose of validating in particular range?how we can validated some selected cells? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validating
Validation enables you to restrict the values that a User is allowed to
enter into a cell - you might have a formula which expects integer values, for example, so you don't want to allow any fractional values. Or, you might calculate the square root of a number - obviously, you do not want negative numbers to be entered. You can also restrict input to only certain values, by setting up a list in the sheet and only allowing choices to be made from that list (via a pull-down). To apply validation, select the cell(s) you want this to apply to and Data | Validation - the dialogue box allows you to specify the restrictions and also on other tabs you can specify an optional message which you might want to display when the cell is selected (e.g. "Please enter positive integer") as well as the error message to display and the action to be taken when the data is not valid. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validating non-blank cells in Excel 'form' | Excel Discussion (Misc queries) | |||
Validating | Excel Discussion (Misc queries) | |||
validating data in a combobox | Excel Worksheet Functions | |||
Validating hyperlinks and text for hyperlink | Excel Discussion (Misc queries) | |||
Validating data pasted into worksheet | Excel Discussion (Misc queries) |