Shortcuts & hacks

Anki

 * Cloze multiple words on one card at the same time: select the word to disappear and then CTRL+SHIFT+ALT+C
 * Mit Link unterlegen: CTRL+SHIFT+H
 * Preview in the adding window: CTRL+l (lower case L)
 * Fractions: \frac{x}{y}, then mark expression and click options/three bars and select MathJax inline
 * Remove formatting: CTRL + R
 * Greek letters: \alpha for lowercase and \Alpha for uppercase etc

Word

 * Decrease indent: CTRL + SHIFT + M

Gmail

 * Toggle star/rotate among superstars: s
 * Delete: #
 * Reply: r
 * Reply in a new window: Shift + r
 * Reply all: a
 * Forward: f
 * Undo last action: z
 * Mark as read: Shift + i
 * Mark as unread: Shift + u
 * Go to Inbox: g + i
 * Go to Sent messages: g + t
 * Go to Tasks: g+k
 * Compose: c
 * Compose in a new tab: d
 * Search mail: /
 * Open "move to" menu: v

Excel

 * To fill all empty cells with "NA": select the data range, press CTRL+G, Special, Blanks, click OK, now press F2 and type in "NA", press CTRL+Enter to auto-populate all cells with this
 * To jump to last data entry in Excel: CTRL+arrow
 * If you an operation where one reference changes (i.e. being able to drag down the operation) but another input for the operation should remain one specific cell, place $ signs around the letter. For example: I want "=I34-H36" and in the next cell "=I35-H36" and so on. Then I type "I34-$H$36" and then drag this down
 * To freeze first column and row, select B2 (because its the first cell that includes both the first row and column, i.e. everything above/to the left will be frozen)
 * Wenn ich als Operation habe, den Wert der obigen Zelle zu übernehmen (also bspw. in Zelle A2 steht "=A1"), kann ich auch die Zelle anklicken und statt die Operation nach unten zu ZIEHEN einfach doppelt klicken, dann vervollständigt Ecel automatisch