top of page

Learn and save your time with excel short cuts


Ctrl + A - Select All


Ctrl + B - Bold


Ctrl + C - Copy


Ctrl + D - Fill


Ctrl + F - Find


Ctrl + G - Find next instance of text


Ctrl + H - Replace


Ctrl + I - Italic


Ctrl + K - Insert a hyperlink


Ctrl + N - New workbook


Ctrl + O - Open


Ctrl + P - Print


Ctrl + R - Nothing right


Ctrl + S - Save


Ctrl + U - Underlined


Ctrl + V - Paste


Ctrl W - Close


Ctrl + X - Cut


Ctrl + Y - Repeat


Ctrl + Z - Cancel


F1 - Help


F2 - Edition


F3 - Paste the name


F4 - Repeat the last action


F5 - Goto


F6 - Next Pane


F7 - Spell Check


F8 - Extension of the mode


F9 - Recalculate all workbooks


F10 - Activate Menubar


F11 - New graph


F12 - Save As


Shift + F1 - What is it?


Shift + F2 - Edit cell comment


Shift + F3 - Paste the function into the formula


Shift + F4 - Search Next


Shift + F5 - Find


Shift + F6 - Previous Panel


Shift + F8 - Add to the selection


Shift + F9 - Calculate the active worksheet


Shift + F10 - Popup menu display


Shift + F11 - New spreadsheet


Shift + F12 - Save


Ctrl + F3 - Set name


Ctrl + F4 - Close


Ctrl + F5 - XL, size of the restore window


Ctrl + F6 - Next Workbook Window


Shift + Ctrl + F6 - Previous Workbook Window


Ctrl + F7 - Move window


Ctrl + F8 - Resize Window


Ctrl + F9 - Minimize the workbook


Ctrl + F10 - Maximize or Restore Window


Ctrl + F11 - Inset 4.0 Macro sheet


Ctrl + F1 - Open File


Alt + F1 - Insert a graph


Alt + F2 - Save As


Alt + F4 - Output


Alt + F8 - Macro dialog


Alt + F11 - Visual Basic Editor


Ctrl + Shift + F3 - Create a name using the names of row and column labels


Ctrl + Shift + F6 - Previous Window


Ctrl + Shift + F12 - Printing


Alt + Shift + F1 - New spreadsheet


Alt + Shift + F2 - Save


Alt + = - AutoSum


Ctrl + `- Toggle value / display of the formula


Ctrl + Shift + A - Insert the argument names in the formula


Alt + down arrow - automatic view list


Alt + '- Format Style Dialog


Ctrl + Shift + ~ - General Format

 
 
 

Comments


bottom of page