Mac users: Access your menu bar and launch dock items from the comfort of your keyboard with the Ctrl-F2 (menu bar) and Ctrl-F3 (dock) shortcuts. Especially handy for former Windows users used to ...
CTRL + SHIFT + F3: Create names automatically from the labels of rows and (or) columns. CTRL + F3: Set a name to a cell range F3: To paste a predefined name. ALT + =: This allows you to insert a Sum ...