In the Spreadsheet of a CASIO 9860, cells can contain either a numerical value, text or a formula. Each of these are entered in slightly different ways.

Numerical values can be entered directly from the keypad.

To enter text, start by putting the 9860 into ‘alpha lock’ mode. This is done by pressing SHIFT then ALPHA. The red text letters can then be entered.

All text entries need to start with the quotation marks (“). This symbol can be entered via EXP.

Text can now be typed, using the red letters above the keys as required. Note that SPACE is above the decimal.

Press EXE to complete your entry.