Entering spreadsheet data

    To enter data in a cell:
    1 Click the cell.
    2 Type the data or formula.
    As you type, the data appears in the entry bar, just below the document window title bar. The data scrolls to the left if you type more than can fit in the entry bar.
    IMPORTANT: To avoid confusion when entering dates, always use 4-digit years. In order for AppleWorks to interpret 4-digit years properly, click "Show century" in the Date Formats dialog box of the Date & Time control panel (in the Apple menu).
    3 Confirm your entry with one of the following methods:
    • Press the Enter key. (The next cell selected depends on your spreadsheet preferences.)
    • To remain in the same cell, click the Accept button, to the left of the entry bar.
    • To move to the cell below, press Return.
    • To move to the cell to the right, press Tab.
    • To move to the cell above, press Shift-Return.
    • To move to the cell to the left, press Shift-Tab.
    Tip: Depending on your spreadsheet preferences, you can also use the arrow keys to move to other cells.
    To cancel what you typed and restore the previous contents of the cell, click the Cancel button, to the left of the entry bar, before confirming your entry.
    Or press the Esc (Escape) key.

    Tip: If you select a cell range, you can press Tab, Return, or any of the arrow keys to move just within the selected cells.

    If you can't edit a cell:
    The cell might be locked. Unlock the cell to edit it.

    If the text data in a cell is truncated:
    The cell width is too narrow to accommodate it. Either resize the column or turn on word wrap.

    If you see number signs (#) in a cell:
    The cell width is too narrow to accommodate the number, date, or time in it. Resize the column to see all the data.

    If numeric data is displayed in scientific notation:
    Either the cell width is too narrow to accommodate the data in it (resize the column) or the number is too large for AppleWorks to display in any other format (AppleWorks displays a maximum of 11 digits in cells).

Related topics

 
Table of contents | Index