11 very useful excel keyboard shortcuts you may not know

1. – During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
2. + – Inserts current date
3. + – Copies value from cell above to current cell
4. + – Edits a cell comment
5. + – Opens macro dialog box
6. + – Auto sum selected cells and places value in cell beneath
7. ++ – Currency formats current cell
8. ++ – Applies outline border to selected cells
9. ++ – Comma formats current cell
10. ++ – Activates font drop down list
11. ++ – Activates font point size drop down list

What is your favorite keyboard shortcut / productivity tip?