Lögmæti

Defines what data is valid for a selected cell or cell range.

Til að nálgast þessa skipun...

Choose Data - Validity.


Táknmynd fyrir góð ráð

You can also insert a list box from the Controls toolbar and link the list box to a cell. This way you can specify the valid values on the Data page of the list box properties window.


Forsenda

Specify the validation rules for the selected cell(s).

Innsláttarhjálp

Enter the message that you want to display when the cell or cell range is selected in the sheet.

Villuáminning

Define the error message that is displayed when invalid data is entered in a cell.

Reset

Resets changes made to the current tab to those applicable when this dialog was opened.