Chapter 8 Pocket Sheet

Comma

•Tap the check box to toggle comma separators every three digits on (checked) and off (unchecked).

Lock

•Tap the check box to toggle cell lock on (checked) and off (unchecked).

•Note that the sheet where the locked cell is located must be a protected sheet (page 107) for the cell’s locked status to be enforced. The content of a cell can always be edited whenever the sheet where it is located is unprotected, even if the cell is locked. The following shows the relationship between the cell lock and sheet protection.

Cell Status

Sheet Status

Cell Content Editing

Locked

Protected

Not allowed

 

 

 

Locked

Unprotected

Allowed

 

 

 

Unlocked

Protected

Allowed

 

 

 

Unlocked

Unprotected

Allowed

 

 

 

Specifying Cell Border Lines

1.Select the range of cells whose borderlines you want to change.

• See “Making a Cell the Active Cell” on page 85.

2.Tap Menu Bar to display the menu bar, and then tap Option – Border.

3.On the screen that appears, tap the borderline option you want to select.

To select this type of border line:

Tap this button:

Bold outer lines only

Normal outer lines only

Normal outer lines and inner lines

Borderlines off

4.When the borderlines are the way you want, tap Exe to apply them and to close the Border screen.

96