Useful Excel Tips for TM1 Operations

(F8) - Toggles whether to extend a selection with the arrow keys.

(Ctrl + Spacebar) - Selects the current column.

(Shift + Spacebar) - Selects the current row.
   
(Ctrl + Shift + 8) - Selects the current region (block of contiguous cells).

(Ctrl + Shift + Spacebar) - Selects the whole worksheet.

(Shift + F4) - Repeat last find.

(Ctrl + Backspace) - return to the active cell.

(Ctrl + Arrow Key) - Move to the edge of next data region (cells that contains data).

(Ctrl + Shift + Arrow Key) - Selects the rest whole worksheet.

(Ctrl + D) - Fill complete cell down (Copy above cell).

(Ctrl + R) - Fill complete cell to the right (Copy cell from the left).

It is possible to change the active cell in a selected range without changing the whole selection by using the Enter key to manoeuvre within the selection.

F9 = recalculate all worksheets in all open workbooks

SHIFT-F9 = recalculate the active spreadsheet only ( but not rebuild the active forms).

CTRL-F9 =  minimizes a workbook window to an icon.

Ctrl-Alt-F9 = recalculate all worksheets in all active workbooks

CTRL-ALT-SHIFT-F9 = "relink" the workbook to Tm1 when the connection was "confused" between Excel and "Perspectives".

Alt-F9 = rebuild of the active form

F2-Enter = recalculate a single cell