Excel keyboard shortcuts mac full#
Excel keyboard shortcuts mac mac#

These shortcuts are much faster then dragging the mouse or highlighting cells. The following shortcuts select entire rows, columns, or tables. To use these keys as standard F1, F2, and F3 keys, combine them with the Fn key.

Some keyboards have multimedia functions for the F1-F12 keys. Note that F4 can do two separate but important things:

Excel keyboard shortcuts mac mac#

Replace dialog вЊѓ H Ctrl H Bold вЊ B Ctrl B Italics вЊ I Ctrl I Underline вЊ U Ctrl UДЄdvanced Shortcuts Action Mac Windows Insert Comment Fn в‡§ F2 Shift F2 Add Hyperlink вЊ K Ctrl K Calculate Formulas F9 F9 Absolute Address F4 F4 Repeat Last Action F4 F4 Show Formulas ^ ` Ctrl ` Enter Current Date вЊѓ Ctrl Enter Current Time вЊ Ctrl Shift : Delete (dialog box) вЊ вЂ“ Ctrl вЂ“ Insert (dialog box) вЊ + Ctrl Shift + Flash Fill вЊѓ E Ctrl E AutoSum вЊ в‡§ T Alt = Select Tab to the Right вЊҐ в†’ Ctrl PgDn Select Tab to the Left вЊҐ в†ђ Ctrl PgUp Action Mac Windows Help вЊ / F1 Undo вЊ Z Ctrl Z Redo вЊ Y Ctrl Y Copy вЊ C Ctrl C Cut вЊ X Ctrl X Paste вЊ V Ctrl V Paste Special вЊѓ вЊ V Ctrl Alt V Find вЊ F Ctrl F Select All вЊ A Ctrl A Edit cell вЊѓ U F2 Open the You need to know Copy, Cut, Paste, and Undo. Keyboard shortcuts are much faster than using a mouse or trackpad to use the menu. The following shortcuts are used to edit in Excel. Here is a top rated wireless keyboard with a number keypad for both Windows and Mac (Amazon affiliate link). Learn to use Excel keyboard shortcuts instead of the mouse or trackpad. Action Arrows Mac Windows Enter and cell down в†“ вЏЋ Return Enter and cell up в†‘ в‡§ вЏЋ Shift Return Enter and cell right в†’ Tab Tab Enter and cell left в†ђ в‡§ Tab Shift Tab With the following shortcuts, you can force the cell to move in any direction. When you enter data and hit вЏЋ (Enter), Excel will save the data and move to the cell directly below. The following shortcuts allow for rapid data entry. Action Mac Windows New workbook вЊ N Ctrl N Open workbook вЊ O Ctrl O Save workbook вЊ S Ctrl S Save as вЊ в‡§ S F12 Print вЊ P Ctrl P Close workbook вЊ W Ctrl F4 Quit Excel вЊ Q Alt F4 The following keyboard shortcuts relate to opening, saving, and printing files. Modifier Keys Special Key Mac Windows Alt or Option вЊҐ Alt Cancel Esc Esc Command вЊ Cmd Control вЊѓ Ctrl Enter or Return вЏЋ Enter Function fn Fn Shift в‡§ ShiftДЇor a list of all the keyboard symbols, see What are the Keyboard Symbol Names? File Shortcuts These are great to be a proficient user of Excel. Excel Keyboard ShortcutsД®xcel uses several modifier keys to perform different functions.

Excel keyboard shortcuts mac full#

The full keyboard also includes a number keypad which is important for entering numbers in Excel. Many Excel users use a full external keyboard to use these shortcuts. Using Excel shortcuts is faster and more efficient than using a mouse.

This guide will show the basics using Excel keyboard shortcuts.

Using Excel quickly and efficiently is an important skill.