Frequently Used Microsoft Excel Keyboard Shortcuts

TheDataLabs

No matter whether you are new to Excel or familiar with this amazing tool, it will always surprise by the number and variety of keyboard shortcuts. Excel shortcuts will always help you in speeding up your work and generally make things more convenient.

As the list of Excel shortcut is very large, it will very difficult for anyone to memorize all the keyboard combos. Everyone’s requirement is different, so some of the keyboard shortcuts will be more useful to you than others.

Here, we’ve compiled the most useful shortcuts that will help you a lot.

General Shortcuts:

  • Ctrl+N                                            Create a new workbook
  • Ctrl+O                                            Open an existing workbook
  • Ctrl+S                                             Save a workbook
  • F12                                                   Open the Save As dialog box
  • Ctrl+W                                          Close a workbook
  • Ctrl+F4                                         Close Excel
  • F4                                                    Repeat the last command or action
  • Shift+F11                                      Insert a new worksheet
  • Ctrl+Z                                            Undo an action
  • Ctrl+Y                                            Redo an action
  • F1                                                     Open the Help pane
  • F7                                                     Check spelling
  • F9                                                    Calculate all worksheets in all open workbooks
  • Shift+F9                                       Calculate active worksheets
  • Ctrl+F1                                          Show or hide the ribbon
  • Ctrl+Shift+U                              Expand or collapse the formula bar
  • Ctrl+F9                                         Minimize the workbook window
  • Ctrl+F                                           Search in a spreadsheet, or use Find and Replace
  • Alt+F                                              Open the File tab menu
  • Ctrl+Tab                                      Switch between open workbooks

Navigating Shortcuts:

  • Left/Right Arrow                          Move one cell to the left or right
  • Ctrl+Left/Right Arrow               Move to the farthest cell left or right in the row
  • Up/Down Arrow                           Move one cell up or down
  • Ctrl+Up/Down Arrow                Move to the top or bottom cell in the column
  • Tab                                                      Go to the next cell
  • Shift+Tab                                         Go to the previous cell
  • Ctrl+End                                          Go to the most bottom right used cell
  • Home                                                 Go to the leftmost cell in the current row
  • Ctrl+Home                                      Move to the beginning of a worksheet
  • Page Up/Down                              Move one screen up or down in a worksheet
  • Alt+Page Up/Down                    Move one screen to the right or left in a worksheet
  • Ctrl+Page Up/Down                   Move to the previous or next worksheet

Cell formatting Shortcuts:

  • Ctrl+B                                            Add or remove bold to the contents of a cell(s)
  • Ctrl+I                                             Add or remove italics to the contents of a cell(s)
  • Ctrl+U                                           Add or remove underline to the contents of a cell(s)
  • Alt+H+H                                      Select a fill color
  • Alt+H+B                                       Add a border
  • Ctrl+Shift+&                              Apply outline border
  • Ctrl+Shift+_                              Remove outline border
  • Ctrl+9                                           Hide the selected rows
  • Ctrl+0                                           Hide the selected columns
  • Ctrl+1                                            Open the Format Cells dialog box
  • Ctrl+5                                           Apply or remove strike through
  • Ctrl+Shift+$                              Apply currency format
  • Ctrl+Shift+%                             Apply percent format

Editing Cells Shortcuts:

  • F2                                                    Edit a cell
  • Shift+F2                                       Add or edit a cell comment
  • Ctrl+X                                           Cut contents of a cell(s)
  • Ctrl+C or Ctrl+Insert            Copy contents of a cell(s)
  • Ctrl+V or Shift+Insert          Paste contents of a cell(s)
  • Ctrl+Alt+V                                  Open the Paste Special dialog box
  • Delete                                            Remove the contents of a cell(s)
  • Alt+H+D+C                                Delete column
  • Esc                                                  Cancel an entry in a cell or the formula bar
  • Enter                                             Complete an entry in a cell or the formula bar

LEAVE A REPLY

Please enter your comment!
Please enter your name here