231 Keyboard Shortcut Keys In Excel
A good knowledge of keyboard shortcuts for Excel helps user work more efficiently. The Excel shortcut keys make us work 10 times faster than using the normal conventional way to solve office challenges.
Sometimes, computer users wonder how proficient their colleagues are in using Microsoft Office Excel without the aide of mouse. This post is all about showing you that there’s no magic in excel like using shortcut keys to manipulate records swiftly without breaking your back.
For easy and quick result, we have compiled over 230 Comprehensive Keyboard shortcuts in Excel for Windows.
Below is a listing of most of the major shortcut keys and key combinations usable in Microsoft Excel.
File tab Shortcut Keys |
|
| Close current workbook | Ctrl+F4 |
| Close Excel | Alt+F4 |
| Create new workbook | Ctrl+N |
| Open print preview window | Ctrl+F2 |
| Open workbook | Ctrl+O |
| Print file | Ctrl+P |
| Save as | F12 |
| Save workbook | Ctrl+S |
General Excel Shortcut |
|
| Copy selected cells | Ctrl+C |
| Create chart in new worksheet | F11 |
| Create embedded chart | Alt+F1 |
| Cut selected cells | Ctrl+X |
| Display find and replace | Ctrl+F |
| Display find and replace, replace selected | Ctrl+H |
| Display the Paste Special dialog box | Ctrl+AltV |
| Find next match | Shift+F4 |
| Find previous match | Ctrl+Shift+F4 |
| Open help | F1 |
| Open options | Alt+FT |
| Paste content from clipboard | Ctrl+V |
| Redo last action | Ctrl+Y |
| Repeat last action | F4 |
| Undo last action | Ctrl+Z |
Cell edit mode Shortcut Keys in Excel |
|
| Edit the active cell | F2 |
| Backspace | Delete |
| Cancel entry | Esc |
| Delete | Fn+Delete |
| Delete character to the left of cursor | Backspace |
| Delete character to the right of cursor | Delete |
| Delete to end of line | Ctrl+Delete |
| Insert or edit comment | Shift+F2 |
| Move one word left | Ctrl+← |
| Move one word right | Ctrl+→ |
| Select one character left | Shift+← |
| Select one character right | Shift+→ |
| Select one word left | CtrlShift+← |
| Select one word right | CtrlShift+→ |
| Select to beginning of cell | Shift+Home |
| Select to end of cell | Shift+End |
| Start a new line in the same cell | Alt+Enter |
Excel Shortcut for Entering data |
|
| Add hyperlink | Ctrl+K |
| Complete entry and stay in same cell | Ctrl+Enter |
| Copy formula from cell above | Ctrl+’ |
| Copy value from cell above | Ctrl+Shift+” |
| Display AutoComplete list | Alt+↓ |
| Enter | Return |
| Enter and move down | Enter |
| Enter and move left | Shift+Tab |
| Enter and move right | Tab |
| Enter and move up | Shift+Enter |
| Enter same data in multiple cells | Ctrl+Enter |
| Fill down from cell above | Ctrl+D |
| Fill right from cell left | Ctrl+R |
| Flash fill | Ctrl+E |
| Insert current date | Ctrl+; |
| Insert current time | Ctrl+Shift+: |
Selection Shortcut Keys in Excel |
|
| Add adjacent cells to selection | Shift+Click |
| Add non-adjacent cells to selection | Ctrl+Click |
| Cancel selection | Esc |
| Move left between non-adjacent selections | Ctrl+Alt+← |
| Move right between non-adjacent selections | Ctrl+Alt+→ |
| Select entire column | Ctrl+Space |
| Select entire row | Shift+Space |
| Select entire worksheet | Ctrl+A |
| Toggle add to selection mode | Shift+F8 |
Active Cell Shortcuts |
|
| Move active cell clockwise in selection | Ctrl+. |
| Move active cell down in selection | Enter |
| Move active cell left in a selection | ShiftTab |
| Move active cell right in a selection | Tab |
| Move active cell up in selection | Shif+~Enter |
| Select active cell only | Shift+Backspace |
| Show the active cell on worksheet | Ctrl+Backspace |
Excel Shortcut for Extend Selection |
|
| Extend selection by one cell down | Shift+↓ |
| Extend selection by one cell left | Shift+← |
| Extend selection by one cell right | Shift+→ |
| Extend selection by one cell up | Shift+↑ |
| Extend selection down one screen | Shift+Pg+Dn |
| Extend selection left one screen | Alt+Shift+PgUp |
| Extend selection right one screen | Alt+Shift+PgDn |
| Extend selection to first cell in worksheet | Ctrl+Shift+Home |
| Extend selection to last cell in worksheet | Ctrl+Shift+End |
| Extend selection to start of row | Shift+Home |
| Extend selection up one screen | Shift+PgUp |
| Extend the selection to the last cell down | Ctrl+Shift+↓ |
| Extend the selection to the last cell left | Ctrl+Shift+← |
| Extend the selection to the last cell right | Ctrl+Shift+→ |
| Extend the selection to the last cell up | Ctrl+Shift+↑ |
| Toggle extend selection mode | F8 |
Select Special Shortcut |
|
| Display ‘Go To’ dialog box | Ctrl+G |
| Select all dependents | Ctrl+Shift+} |
| Select all precedents | Ctrl+Shift+{ |
| Select cells with comments | Ctrl+Shift+O |
| Select column differences | Ctrl+Shift+| |
| Select current array | Ctrl+/ |
| Select current region | Ctrl+A |
| Select current region around active cell | Ctrl+Shift+* |
| Select direct dependents | Ctrl+] |
| Select direct precedents | Ctrl+[ |
| Select row differences | Ctrl+\ |
| Select visible cells only | Alt+; |
Shortcut for Formatting |
|
| Add or remove the outline font style | |
| Align center | Alt+H+A+C |
| Align left | Alt+H+A+L |
| Align right | Alt+H+A+R |
| Apply or remove bold formatting | Ctrl+B |
| Apply or remove italic formatting | Ctrl+I |
| Apply or remove strikethrough formatting | Ctrl+5 |
| Apply or remove underscoring | Ctrl+U |
| Decrease font size one step | Alt+H+F+K |
| Display Format Cells with Font tab selected | Ctrl+Shift+F |
| Format (almost) anything | Ctrl+1 |
| Increase font size one step | Alt+H+F+G |
| Indent | Alt+H+6 |
| Remove indent | Alt+H+5 |
Number Formatting Shortcut Keys |
|
| Apply currency format | Ctrl+Shift+$ |
| Apply date format | Ctrl+Shift+# |
| Apply general format | Ctrl+Shift+~ |
| Apply number format | Ctrl+Shift+! |
| Apply percentage format | Ctrl+Shift+% |
| Apply time format | Ctrl+Shift+@ |
Borders Shortcut in Excel |
|
| Add border outline | Ctrl+Shift+& |
| Add or remove border bottom | Alt+B |
| Add or remove border right | Alt+L |
| Add or remove border top | Alt+T |
| Add or remove border upward diagonal | Alt+D |
| Add or remove border vertical interior | Alt+V |
| Remove borders | Ctrl+Shift+_ |
Excel Shortcut Keys for Formulas |
|
| Toggle absolute and relative references | F4 |
| Accept function with autocomplete | Tab |
| Autosum selected cells | Alt+= |
| Calculate active worksheet | Shift+F9 |
| Define name | Ctrl+F3 |
| Define name using row and column labels | Ctrl+Shift+F3 |
| Display function arguments dialog box | Ctrl+A |
| Expand or collapse the formula bar | Ctrl+Shift+U |
| Insert function arguments | Ctrl+Shift+A |
| Open the Insert Function Dialog Box | Shift+F3 |
| Open the Insert Function Dialog Box | Shift+F3 |
| Paste name into formula | F3 |
| Toggle formulas on and off | Ctrl+` |
Shortcut for Ribbon |
|
| Activate access keys | Alt |
| Activate or open selected control | Space |
| Confirm control change | Enter |
| Expand or collapse ribbon | Ctrl+F1 |
| Get help on selected control | F1 |
| Move to next ribbon control | Tab |
Shortcut for Tables and Filters in Excel |
|
| Activate filter | Alt+? |
| Clear slicer filter | Alt+C |
| Insert table | Ctrl+T |
| Select table | Ctrl+A |
| Select table column | Ctrl+Space |
| Select table row | Shift+Space |
| Toggle Autofilter | Ctrl+Shift+L |
| Toggle table total row | Ctrl+Shift+T |
Drag and Drop buttons |
|
| Drag and cut | drag |
| Drag and copy | Ctrl+drag |
| Drag and insert | Shift+drag |
| Drag and insert copy | Ctrl+Shift+drag |
| Drag to duplicate worksheet | Ctrl+drag |
| Drag to worksheet | Alt+drag |
Excel Shortcut Keys for Navigation |
|
| Go back to hyperlink | Ctrl+G+Enter |
| Move one cell down | ↓ |
| Move one cell left | ← |
| Move one cell right | → |
| Move one cell up | ↑ |
| Move one screen down | PgDn |
| Move one screen left | Alt+PgUp |
| Move one screen right | Alt+PgDn |
| Move one screen up | PgUp |
| Move to beginning of row | Home |
| Move to bottom edge of data region | Ctrl+↓ |
| Move to first cell in worksheet | Ctrl+Home |
| Move to last cell in worksheet | Ctrl+End |
| Move to left edge of data region | Ctrl+← |
| Move to right edge of data region | Ctrl+→ |
| Move to top edge of data region | Ctrl+↑ |
| Turn End mode on | End |
Grid Operations |
|
| Delete cells | Ctrl+- |
| Delete columns | Ctrl+- |
| Delete contents of selected cells | Delete |
| Delete rows | Ctrl+- |
| Display Delete dialog box | Ctrl+- |
| Group rows or columns | Alt+Shift+→ |
| Hide columns | Ctrl+0 |
| Hide or show outline symbols | Ctrl+8 |
| Hide rows | Ctrl+9 |
| Insert columns | Ctrl+Shift+ |
| Insert rows | Ctrl+Shift+ |
| Open Group Dialog Box | Alt+Shift+→ |
| Open Ungroup Dialog Box | Alt+Shift+← |
| Ungroup rows or columns | Alt+Shift+← |
| Unhide columns | Ctrl+Shift+0 |
| Unhide rows | Ctrl+Shift+9 |
| Zoom in | Ctrl+Alt+ |
| Zoom out | Ctrl+Alt+- |
Pivot Tables |
|
| Create pivot chart on new worksheet | F11 |
| Create pivot chart on same worksheet | Alt+F1 |
| Group pivot table items | Alt+Shift+→ |
| Hide pivot table item | Ctrl+- |
| Open pivot table wizard | Alt+D+P |
| Select entire pivot table | Ctrl+A |
| Toggle pivot table field checkbox | Space |
| Ungroup pivot table items | Alt+Shif=t← |
Excel Workbook Shortcut Keys |
|
| Accept and apply | Enter |
| Cancel and close the dialog box | Esc |
| Check and uncheck box | Space |
| Go to next workbook | Ctrl+Tab |
| Go to next worksheet | CtrlPgDn |
| Go to previous workbook | Ctrl+Shift+Tab |
| Go to previous worksheet | Ctrl+PgUp |
| Insert new worksheet | Shift+F11 |
| Maximize current workbook window | Ctrl+F10 |
| Minimize current workbook window | Ctrl+F9 |
| Move to next control | Tab |
| Move to next pane | F6 |
| Move to next tab | Ctrl+Tab |
| Move to previous control | Shift+Tab |
| Move to previous pane | Shift+F6 |
| Move to previous tab | Ctrl+Shift+Tab |
| Select adjacent worksheets | Shift+Click |
| Select non-adjacent worksheets | Ctrl+Click |
| Toggle full screen | Ctrl+Shift+F1 |
| Toggle scroll lock | ScrLk |
Others Excel Shortcuts |
|
| Open Spelling dialog box | F7 |
| Delete comment | Shift+F10D |
| Display control menu | Alt+Space |
| Display Modify Cell Style dialog box | Alt+’ |
| Display right-click menu | Shift+F10 |
| Duplicate object | Ctrl+D |
| Hide or show objects | Ctrl+6 |
| Open Macro dialog box | Alt+F8 |
| Open Thesaurus dialog box | Shift+F7 |
| Open VBA Editor | Alt+F11 |
| Snap to grid | Alt |