Related Tutorials
Excel Keyboard Shortcuts
Keyboard shortcuts are the quickest way of getting tasks done in Excel. Knowing atleast a few keyboard shortcuts for common tasks can save alot of time.
Download the keyboard shortcuts reference sheet
StandardCtrl + N – New Workbook Ctrl + O – Open Ctrl + W – Close Window Alt + F4 – Quit Excel Ctrl + S – Save Ctrl + P – Print Ctrl + Z – Undo Ctrl + Y – Redo Ctrl + K – Hyperlink Ctrl + ‘ – Copy Cell Above Ctrl + ; - Insert Today's Date Ctrl + + - Insert Row or Column Shift + F11 – New Worksheet F1 – Help F2 – Edit Mode F5 – Go To F7 – Spell Check Alt + F11 – VB Editor |
Selection and NavigationCtrl + F – Find Ctrl + G – Go To Ctrl + H – Replace Ctrl + Arrow - End of Row or Column Ctrl + Home – Start of Worksheet Ctrl + End – End of Worksheet Ctrl + Page Up – Previous Worksheet Ctrl + Page Down – Next Worksheet Ctrl + Tab – Move to Next Open Workbook Ctrl + A - Select All Ctrl + Shift + Arrow - Select Range to End of Row or Column Ctrl + Shift + Home – Select Range to Start of Worksheet Ctrl + Shift + End – Select Range to End of Worksheet Ctrl + Spacebar – Select Column Shift + Spacebar – Select Row |
FormattingCtrl + B – Bold Ctrl + I – Italic Ctrl + U – Underline Ctrl + 1 – Format Cells |
Moving and CopyingCtrl + X – Cut Ctrl + C – Copy Ctrl + V – Paste Click and Drag – Move Ctrl + Click and Drag - Copy |
Follow us on
