Fill a selected cell range with the formula that you entered on the Input line

Apply the cell format of the input cell to the entire cell range

Create a matrix in which all the cells contain the same information. Components of the matrix cannot be edited

To select multiple cells in different areas of a sheet, hold down Ctrl and drag in the different areas

To select multiple sheets in a spreadsheet, hold down Ctrl, and then click the name tabs at the lower edge of the workspace.

To insert a manual line break in a cell, click in the cell, and then press Ctrl + Enter

Moves the cursor to the last cell on the sheet that contains data

Selects cells from the current cell up to one page in the current column or extends the existing selection one page up

Moves one sheet to the left

In the print preview: Moves to the previous print page

where (*) is the multiplication sign on the numeric key pad

where (/) is the division sign on the numeric key pad

Displays or hides the formulas instead of the values in all cells (see note below this table)

Moves the cursor to the Input line where you can enter a formula for the current cell

Traces dependents

Moves the cursor from the Input line to the Sheet area box

Highlights cells containing values

Decreases the height of current row (only in OpenOffice.org legacy compatibility mode)

Standard percentage format (two decimal places)

Standard format