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 for mac keystrokes 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.
0 kommentar(er)
