naxfin.blogg.se

You need to know Copy, Cut, Paste, and Undo. Excel 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 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.