Apply the built-in cell style number format with two decimal places.

Apply filter for current selection.

[Alt-=] Places SUM formula(s) below the selection.

[Backspace] Enters cell edit mode with empty text in the cell.

[Ctrl-B] [Ctrl-2] Toggles bolding on and off for the current selection.

[F9] Calculate all worksheets in all open workbooks. [Shift-F9] Calculate the active worksheet only.

[Esc] Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's original state.

Check AutoFilter and Sort availability.

Check AutoFilter availability.

Clear all from selected cells

Clear sort filter for current selected autofilter.

Clear format from selected cells

[Ctrl-'] Copies the formula in the cell above to the active (current) current cell and leaves the cell in edit mode.

[Ctrl-C] Copy puts everything on the clipboard: text, formulas, formatting, borders, fills, etc.

[Ctrl-Shift-"] Copies the value in the cell above to the selected cell and leaves the cell in edit mode. If the cell above is a formula, only the value is copied.

[Ctrl-Shift-$] Apply the Currency format with two decimal places.

[Ctrl-X] Cut puts everything on the clipboard: text, formulas, formatting, borders, fills, etc.

[Ctrl-Shift-#] Apply the Date format with the day, month, and year.

[Delete] Deletes the cell value.

[F2] Enters cell edit mode with the cursor at the end of the last line of text in the cell.

Start editing name of the active worksheet.

[Ctrl-Shift-Enter] Enter an array formula.

[Ctrl-Enter] With multiple cells selected, this shortcut will enter the same data in all cells in the selection at once. With a single cell selected, this shortcut will enter a value and leave the same cell selected.

[Ctrl-Shift-Down] Extend the entire bottom edge of the current selection.

[Ctrl-Shift-Left] Extend the entire left edge of the current selection.

[Ctrl-Shift-Right] Extend the entire right edge of the current selection.

[Ctrl-Shift-Up] Extend the entire top edge of the current selection.

[Shift-Down] Extend the entire bottom edge of the current selection.

[Shift-Left] Extend the entire left edge of the current selection.

[Shift-Right] Extend the entire right edge of the current selection.

[Shift-Up] Extend the entire top edge of the current selection.

[Shift-PgDn] The distance moved down depends on the size of the worksheet window.

[Alt-Shift-PgUp] Extends the current selection one screen to the left.

[Alt-Shift-PgDn] Extends the current selection one screen to the right.

[Shift-PgUp] The distance moved up depends on the size of the worksheet window.

Adjust selection cells Vertical/Horizontal Alignment

[Ctrl-1] Displays the Format Cells dialog box with the "last tab used" selected.

[Ctrl-Shift-~] Apply the General number format.

[Ctrl-0] Hide columns that intersect the current selection. [Ctrl-9] Hide rows that intersect the current selection. [Ctrl-Shift-0] Unhide any hidden columns that intersect the current selection. [Ctrl-Shift-9] Unhide any hidden rows that intersect the current selection.

[Ctrl-;] Insert the current date as a fixed value.

[Ctrl-Shift-:] Insert the current time as a fixed value.

[Ctrl-I] [Ctrl+3] Toggles italics on and off for the current selection.

[Enter] Cycle through every cell in a selection, moving from top left to bottom right. [Shift-Enter] Cycle through every cell in a selection, moving from bottom right to top left. [Tab] Move the active cell right one cell when there are multiple cells selected. [Shift-Tab] Move the active cell left one cell when there are multiple cells selected. [Ctrl-.] Cycle through every cell in a selection, moving from top left to bottom right.

[Down] Moves current selection one cell below the active selection.

[PgDn] Moves current selection one screen below the active selection.

[Ctrl-Down] If the active cell is empty, Spread will stop on the first non-empty cell below the active cell. If the active cell is non-empty, Spread will stop on the last non-empty cell below the active cell.

[Ctrl + Down] Moves the current selection to the next non empty row in column data cell;

[Ctrl + Left] Moves current selection to the previous non empty column in row data cell;

[Ctrl + Right] Moves the current seleciton to the next non empty column in row data cell;

[Ctrl + Up] Moves the current selection to the previous non empty row in column data cell;

[Left] Moves current selection one cell to the left of the active selection.

[Alt-PgUp] Moves current selection one screen to the left of the active selection.

[Ctrl-Left] If the active cell is empty, Spread will stop on the first non-empty cell to the left. If the active cell is non-empty, Spread will stop on the last non-empty cell to the left..

[Right] Moves current selection one cell to the right of the active selection.

[Alt-PgDn] Moves current selection one screen to the right of the active selection.

[Ctrl-Right] If the active cell is empty, Spread will stop on the first non-empty cell to the right. If the active cell is non-empty, Spread will stop on the last non-empty cell to the right.

[Ctrl+Home] If freeze pane is enabled, this shortcut will go to the upper left cell in the current pane. If freeze pane is not enabled, this shortcut will go the cell upper left cell in the worksheet (A1).

[Home] Moves to beginning of row.

[Ctrl+End] The last cell is at the intersection of the last row that contains data and the last column that contains data. The last cell may or may not contain data.

[End] Moves to ending of row.

[Up] Moves current selection one above the active selection.

[PgUp] Moves current selection one screen above the active selection.

[Ctrl-Up] If the active cell is empty, Spread will stop on the first non-empty cell above the active cell. If the active cell is non-empty, Spread will stop on the last non-empty cell above the active cell.

[Ctrl-Shift-!] Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.

[Ctrl-V] Paste will paste everything on the clipboard, both content and formatting.

[Ctrl-Shift-%] Apply the Percentage format with no decimal places.

Re-apply sort filter for current selected autofilter.

[Ctrl-Shift-^] Apply the Scientific number format with two decimal places.

[Shift+Backspace] When multiple cells are selected, this shortcut will leave only the active cell selected.

[Ctrl-Space] Select the entire column of the current selection. If the current selection spans multiple columns, all columns that intersect the selection will be selected.

[Shift-Space] Select the entire row of the current selection. If the current selection spans multiple rows, all rows that intersect the selection will be selected.

[Ctrl-A] Select the entire table or worksheet.

Bring shape forward.

Bring shape to the front.

Group the selected drawing object.

Re-group the drawing objects.

Send shape backward.

Send shape to the back.

Un-group the selected drawing object.

[Ctrl+Backspace] Scroll the screen to show the active cell on the worksheet.

[Alt - Down] Show subeditor if celltype has sub editor.

Sort by Ascending/Descending for current selection.

Enters a value and leave the same cell selected.

Enters a value and leave the same sheet's tab selected.

[Ctrl-5] Toggles strikethrough on and off for the current selection.

[Ctrl-Shift-@] Apply the Time format with the hour and minute, and indicate A.M. or P.M.

[Ctrl-U] [Ctrl+4] Toggles underlining on and off for the current selection.