y + F3

Formula box

Strng + Enter = Move up

Strng + r = copies the cell to the left (or formula)

Strng + u = copies the cell above

Alt + arrow down key = shows a pop-up-list to choose from (looks up data in the current table)

Strng + . = date

Strng + : = actual time

Strng + Pos1 = go to A1

Strng + Bild = page down

Strng + shift + arrow = mark an area

Strng + shift + 1

10.000.000,00

Strng + shift + 2

1,00E+07

Strng + shift + 3

#############

Strng + shift + 4

€ 10.000.000,00

Strng + shift + 5

1%

Strng + shift + 6

20,02

Shift + F11 = insert new worksheet

Strng + Shift + F12 = call up where to save a document

Strng + H = ersetzen

Strng + 9 = Markierte ZEILEN ausblenden

(hide)

Strng + 8 = Markierte SPALTEN ausblenden

Strng + Shift + 9 = Zeilen in markierten Bereich einblenden

(unhide)

Strng + Shift + 0 = Spalten in markierten Bereich einblenden

Diagrams

Prepare Graph

Alt + F1 = layout changes to line bar graph

F11 = then moves diagram to its own spreadsheet

Summewenns()

Zählenwenns()

Mittelwertwenn()

Mittelwertwenns()

Modalwert()

Arbeitstag.intl()

Nettoarbeitstage.intl()