Excel shortcut

Page 1

PC shortcuts & Mac shortcuts Editing shortcuts Edit active cell F2 Ctrl U Cut Ctrl X ⏳ X Copy Ctrl C ⏳ C Paste Ctrl V ⏳ V Paste Special Alt E S ⏳ Shift V Paste name into formula F3 Toggle references F4 ⏳ T Start a new line within the same cell Alt Enter Ctrl Option Return Insert or edit cell comment Shift F2 Shift F2 Display shortcut menu (i.e. same as right click) Shift F10 Shift F10 Insert worksheet Shift F11 Shift F11 Define a name for a cell Ctrl F3 Ctrl F3 Fill down (e.g. copy formula down in selected cells) Ctrl D Ctrl D Fill right Ctrl R Ctrl R Insert argument names and parentheses for a function after typing a function name in a formula Ctrl Shift A Ctrl Shift A Insert row Alt I R Ctrl I Insert column Alt I C Ctrl I Formatting Shortcuts Brings up format cells menu Ctrl 1 ⏳ 1 Bold Ctrl B ⏳ B Italic Ctrl I ⏳ I Undo Ctrl Z ⏳ Z Repeat last action Ctrl Y ⏳ Y Select all used cells (select entire worksheet if command is repeated) Ctrl A ⏳ A Number format Ctrl Shift ! Ctrl Shift ! Date format Ctrl Shift # Ctrl Shift # Percent format Ctrl Shift % Ctrl Shift % Increase font size Alt h fg ⏳ Shift > Decrease font size Alt h fk ⏳ Shift < Increase decimal Alt h Decrease decimal Alt h 9 Increase indent Alt h 6 Ctrl M Decrease indent Alt h 5 ⏳ Shift m Navigation Shortcuts Move from cell to cell Arrows Arrows Go to F5 F5 Go to cell A1 Ctrl Home Fn Ctrl Left Go to beginning of row Home Fn Left Select the adjacent cell Shift Arrow Shift Arrow Select entire row Shift Spacebar Shift Spacebar Select entire column Ctrl Spacebar Ctrl Spacebar Select all to the start of the sheet Ctrl Shift Home Ctrl Shift Home Select all to the last used cell of the sheet Ctrl Shift End Ctrl Shift End Select to the end of the last used cell in row/column Ctrl Shift Arrow Ctrl Shift Arrow Select the…