means only integer values are allowed. Fractional values are not allowed. In the Data field, select less than and in the Maximum field type . Refer Figure .
. Figure . Screen shot of validity dialogue box (Criteria Tab) Then select Error Alert Tab, select "Show error message when invalid values are entered" check box. Then select Warning in the Action dropdown list box, Enter title of the error message (such as invalid) in the Title text box.
Then type the error message in the Error message multi line text box. Refer Figure . . Figure .
Screen shot of validity dialogue box (Error Alert Tab) Now, in the Roll No column, if the user types values above , the error message will appear as shown in Figure . . Figure . Screen shot of validity error .
Creating and using Input Help List Input Help is used to provide various options such as choosing the gender of a person (Male or Female), Month (Jan,Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec). The following steps will guide to generate the List for Gender. Step : In any one cell (ex: A1) type Gender Step : Select the next cell (may be in A2 or B1) Step : Go to Data → Validity then the dialogue box will appear (refer Figure . ) Figure .
Screen shot of Input Help list Step : Select Input Help Tab, type Title as Gender. then type, Male and Female in the I nput Help Field. Then press “ Ok ”. Step : Goto the selected cell no, the input help message will appear (refer Figure .
). Figure . Screen shot of spread-sheet after applying Input Help list . Printing Spreadsheet .
. Setting the page size, Orientation and Margins Step : To format the page size, go to Format → Page in the menu bar. The dialoge box will appear as shown in Figure . .
Figure . Page Style dialoge box Step : Choose Page Tab (refer Figure . ) Figure . Screen shot of page formattin g Step :