Instead of accessing the toolbar with a mouse, you can perform significant functions using the Excel Shortcut keys. Excel Shortcut keys will be used by big companies, small firms, school and college students, etc. Excel Shortcut keys will help you to record and analyze the data, perform mathematical operations, visualize charts and graphs, etc.
There is no denying that the list of Excel Shortcut keys is pretty too long and by no means will you be able to remember them. However, in order to become an Excel master you must know each and every bit of Excel and its shortcuts. Hence a PDF format of Excel Shortcut keys is available for download.
Most used Excel Shortcut keys
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Copy selected cells |
Ctrl + C |
Command + C |
| Paste content from the clipboard |
Ctrl + V |
Command + V |
| Cut selected cells |
Ctrl + X |
Command + X |
| Undo the last action |
Ctrl + Z |
Command + Z |
| Redo the last action |
Ctrl + Y |
Command + Y |
| Repeat the last action |
F4 |
F4 |
| Paste a Special dialog box |
Ctrl + Alt + V |
Command + Option + V |
| Find and Replace |
Ctrl + F |
Command + F |
| Replace selected |
Ctrl + H |
Command + H |
| Find the previous match |
Ctrl + Shift + F4 |
Command + Shift + F4 |
| Find next match |
Shift + F4 |
Shift + F4 |
| Create embedded chart |
Alt + F1 |
Option + F1 |
| Create a chart in the new worksheet |
F11 |
F11 |
| Open Options |
Alt, F, T |
Option, F, T |
| Open help |
F1 |
F1 |
| Expand or collapse the ribbon |
Ctrl + F1 |
Command + F1 |
| Activate access keys |
Alt |
Option |
| Move to the next ribbon control |
Tab |
Tab |
| Activate or open selected control |
Spacebar |
Spacebar |
| Confirm control change |
Enter |
Return |
| Get help on selected control |
F1 |
F1 |
| Open the spelling dialog box |
F7 |
F7 |
| Open the Thesaurus dialog box |
Shift + F7 |
Shift + F7 |
| Open the Macro dialog box |
Alt + F8 |
Option + F8 |
| Open VBA Editor |
Alt + F11 |
Option + F11 |
| Duplicate object |
Ctrl + D |
Command + D |
| Snap to grid |
Alt |
Option |
| Hide or show objects |
Ctrl + F6 |
Command + F6 |
| Display modify cell-style dialog box |
Alt + ‘ |
Option + ‘ |
| Display right-click menu |
Shift + F10 |
Shift + F10 |
| Delete comment |
Shift + F10, D |
Shift + F10, D |
| Display control menu |
Alt + Spacebar |
Option + Spacebar |
Read More: 46 CATIA V5 Shortcuts for Windows
File Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Create New Workbook |
Ctrl + N |
Command + N |
| Open workbook |
Ctrl + O |
Command + O |
| Save workbook |
Ctrl + S |
Command + S |
| Save as |
F12 |
F12 |
| Print file |
Ctrl + P |
Command + P |
| Open print preview window |
Ctrl + F2 |
Command + F2 |
| Close current workbook |
Ctrl + F4 |
Command + F4 |
| Close Excel |
Alt + F4 |
Option + F4 |
Read More: 25 Feedly Shortcuts You Should Know
Text Formatting Shortcuts
These shortcuts allow you to format cells and data within your worksheets, such as bolding, italicizing, or underlining text, or opening the Format Cells dialog box. Examples include Ctrl + B (bold), Ctrl + I (italicize), Ctrl + U (underline), and Ctrl + 1 (Format Cells).
| Action |
Excel Shortcut keys Windows |
Excel Shortcut keys Mac |
| Apply or remove bold formatting |
Ctrl + B |
Command + B |
| Apply or remove italic formatting |
Ctrl + I |
Command + I |
| Apply or Remove underscoring |
Ctrl + U |
Command + U |
| Apply or remove strikethrough formatting |
Ctrl + 5 |
Command + 5 |
| Align center |
Alt, H, A, C |
Option, H, A, C |
| Align left |
Alt, H, A, L |
Option, H, A, L |
| Align right |
Alt, H, A, R |
Option, H, A, R |
| Indent |
Alt, H, 6 |
Option, H, 6 |
| Remove indent |
Alt, H, 5 |
Option, H, 5 |
| Increase font size one step |
Alt, F, FG |
Option, F, FG |
| Decrease font size one step |
Alt, H, FK |
Option, H, FK |
| Format Cells |
Ctrl + 1 |
Command + 1 |
| Display Format cells with font tab selected |
Ctrl + Shift + F |
Command + Shift + F |
Read More: 10 Pandora Shortcuts You Should Know
Number Formatting Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Apply general format |
Ctrl + Shift + ~ |
Command + Shift + ~ |
| Apply currency format |
Ctrl + Shift + $ |
Command + Shift + $ |
| Apply percentage format |
Ctrl + Shift + % |
Command + Shift + % |
| Apply scientific format |
Ctrl + Shift + ^ |
Command + Shift + ^ |
| Apply date format |
Ctrl + Shift + # |
Command + Shift + # |
| Apply time format |
Ctrl + Shift + @ |
Command + Shift + @ |
| Apply number format |
Ctrl + Shift + ! |
Command + Shift + ! |
Read More: 170 MS Access Shortcut Keys for Windows
Filter Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Activate filter |
Alt + Down Arrow key |
Option + Down Arrow key |
| Toggle Autofilter |
Ctrl + Shift + L |
Command + Shift + L |
| Clear slicer filter |
Alt + C |
Option + C |
| Select the next item in the AutoFilter list |
Down Arrow key |
Down Arrow key |
| Select the previous item in the AutoFilter list |
Up Arrow key |
Up Arrow key |
| Close the AutoFilter list for the current column |
Alt + Up Arrow key |
Option + Up Arrow key |
| Select the first item in the AutoFilter list |
Home key |
Home key |
| Select the last item in the AutoFilter list |
End key |
End key |
Active Cell Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Select active cell only |
Shift + Backspace |
Shift + Backspace |
| Show the active cell on the worksheet |
Ctrl + Backspace |
Command + Backspace |
| Move active cell clockwise in selection |
Ctrl + . |
Command + . |
| Move active cells down in the selection |
Enter |
Return |
| Move active cells up in the selection |
Shift + Enter |
Shift + Return |
| Move active cells right in a selection |
Tab |
Tab |
| Move active cells left in a selection |
Shift + Tab |
Shift + Tab |
Read More: 20 Zendesk Shortcuts You Should Know
Drag and Drop Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Drag and cut |
Drag |
Drag |
| Drag and Copy |
Ctrl + Drag |
Command + Drag |
| Drag and insert |
Shift + Drag |
Shift + Drag |
| Drag and insert copy |
Ctrl + Shift + Drag |
Command + Shift + Drag |
| Drag to worksheet |
Alt + Drag |
Option + Drag |
| Drag to duplicate worksheet |
Ctrl + Drag |
Command + Drag |
Cell Borders Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Add or remove border-right |
Alt, H, B, R |
Option, H, B, R |
| Add or remove border-left |
Alt, H, B, L |
Option, H, B, L |
| Add or remove the border top |
Alt, H, B, T |
Option, H, B, T |
| Add or remove border-bottom |
Alt, H, B, B |
Option, H, B, B |
| Add or remove the border upward diagonal |
Alt, H, B, D |
Option, H, B, D |
| Add or remove the border horizontal interior |
Alt, H, B, H |
Option, H, B, H |
| Add or remove border vertical interior |
Alt, H, B, V |
Option, H, B, V |
| Add border outline |
Ctrl + Shift + & |
Command + Shift + & |
| Remove borders |
Ctrl + Shift + _ |
Command + Shift + _ |
Read More: 80 Apple Numbers Shortcuts for Mac
Data Entering Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Enter and move down |
Enter |
Return |
| Enter and move up |
Shift + Enter |
Shift + Return |
| Enter and move right |
Tab |
Tab |
| Enter and move left |
Shift + Tab |
Shift + Tab |
| Complete entry and stay in the same cell |
Ctrl + Enter |
Command + Return |
| Enter the same data in multiple cells |
Ctrl + Enter |
Command + Return |
| Insert current date |
Ctrl + ; |
Command + ; |
| Insert current time |
Ctrl + Shift + : |
Command + Shift + : |
| Fill down from the cell above |
Ctrl + D |
Command + D |
| Fill right from cell left |
Ctrl + R |
Command + R |
| Copy the formula from the cell above |
Ctrl + ` |
Command + ` |
| Copy value from the cell above |
Ctrl + Shift + “ |
Command + Shift + “ |
| Add hyperlink |
Ctrl + K |
Command + K |
| Display AutoComplete list |
Alt + Down Arrow key |
Option + Down Arrow key |
| Flash Fill |
Ctrl + E |
Command + E |
Cell Edit Mode Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Edit the active cell |
F2 |
F2 |
| Insert or edit the comment |
Shift + F2 |
Shift + F2 |
| Cancel entry |
Esc |
Esc |
| Select one character right |
Shift + Right Arrow key |
Shift + Right Arrow key |
| Select one character left |
Shift + Left Arrow key |
Shift + Left Arrow key |
| Move one word right |
Ctrl + Right Arrow key |
Command + Right Arrow key |
| Move one word left |
Ctrl + Left Arrow key |
Command + Left Arrow key |
| Select one word right |
Ctrl + Shift + Right Arrow key |
Command + Shift + Right Arrow key |
| Select one word left |
Ctrl + Shift + Left Arrow key |
Command + Shift + Left Arrow key |
| Select the beginning of the cell |
Shift + Home |
Shift + Home |
| Select to end of the cell |
Shift + End |
Shift + End |
| Delete to end of line |
Ctrl + Delete |
Command + Delete |
| Delete the character to the left of the cursor |
Backspace |
Backspace |
| Delete the character to the right of the cursor |
Delete |
Delete |
| Start a new line in the same cell |
Alt + Enter |
Option + Return |
Dialog boxes Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Move to the next control |
Tab |
Tab |
| Move to the previous control |
Shift + Tab |
Shift + Tab |
| Move to the next tab |
Ctrl + Tab |
Command + Tab |
| Move to the previous tab |
Ctrl + Shift + Tab |
Command + Shift + Tab |
| Accept and apply |
Enter |
Return |
| Check and uncheck the box |
Spacebar |
Spacebar |
| Cancel and close the dialogue box |
Esc |
Esc |
Navigation Shortcuts
These shortcuts allow you to move around the Excel interface and within and between worksheets, such as moving to the next sheet or returning to the previous sheet. Examples include the arrow keys, Page Up and Page Down, and the Ctrl + G (go to) shortcut.
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Move one cell right |
Right Arrow key |
Right Arrow key |
| Move one cell left |
Left Arrow key |
Left Arrow key |
| Move one cell up |
Up Arrow key |
Up Arrow key |
| Move one cell down |
Down Arrow key |
Down Arrow key |
| Move one screen right |
Alt + Page Down key |
Option + Page Down key |
| Move one screen left |
Alt + Page Up key |
Option + Page Up key |
| Move one screen up |
Page Up key |
Page Up key |
| Move one screen down |
Page Down key |
Page Down key |
| Move to the right edge of the data region |
Ctrl + Right Arrow key |
Command + Right Arrow key |
| Move to the left edge of the data region |
Ctrl + Left Arrow key |
Command + Left Arrow key |
| Move to the top edge of the data region |
Ctrl + Up Arrow key |
Command + Up Arrow key |
| Move to the bottom edge of the data region |
Ctrl + Down Arrow key |
Command + Down Arrow key |
| Move to beginning of the row |
Home key |
Home key |
| Move to the last cell in the worksheet |
Ctrl + End key |
Command + End key |
| Move to the first cell in the worksheet |
Ctrl + Home key |
Command + Home key |
| Turn End Mode on |
End key |
End key |
Selection Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Select entire row |
Shift + Spacebar |
Shift + Spacebar |
| Select entire column |
Ctrl + Spacebar |
Command + Spacebar |
| Select entire worksheet |
Ctrl + A |
Command + A |
| Add adjacent cells to the selection |
Shift + Click |
Shift + Click |
| Add non-adjacent cells to the selection |
Ctrl + Click |
Command + Click |
| Move right between non-adjacent selections |
Ctrl + Alt + Right Arrow key |
Command + Option + Right Arrow key |
| Move left between non-adjacent selections |
Ctrl + Alt + Left Arrow key |
Command + Option + Left Arrow key |
| Toggle add to selection mode |
Shift + F8 |
Shift + F8 |
| Cancel selection |
Esc |
Esc |
Extend Selection Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Extend selection by one cell right |
Shift + Right Arrow key |
Shift + Right Arrow key |
| Extend selection by one cell left |
Shift + Left Arrow key |
Shift + Left Arrow key |
| Extend selection by one cell up |
Shift + Up Arrow key |
Shift + Up Arrow key |
| Extend selection by one cell down |
Shift + Down Arrow key |
Shift + Down Arrow key |
| Extend the selection to the last cell right |
Ctrl + Shift + Right Arrow key |
Command + Shift + Right Arrow key |
| Extend the selection to the last cell left |
Ctrl + Shift + Left Arrow key |
Command + Shift + Left Arrow key |
| Extend the selection to the last cell up |
Ctrl + Shift + Up Arrow key |
Command + Shift + Up Arrow key |
| Extend the selection to the last cell down |
Ctrl + Shift + Down Arrow key |
Command + Shift + Down Arrow key |
| Extend selection up one screen |
Shift + Page Up key |
Shift + Page Up key |
| Extend selection down one screen |
Shift + Page Down key |
Shift + Page Down key |
| Extend selection right one screen |
Alt + Shift + Page Down key |
Option + Shift + Page Down key |
| Extend selection left one screen |
Alt + Shift + Page Up key |
Option + Shift + Page Up key |
| Extend selection to the start of the row |
Shift + Home |
Shift + Home |
| Extend selection to End of row |
Shift + End |
Shift + End |
| Extend selection to the first cell in the worksheet |
Ctrl + Shift + Home |
Command + Shift + Home |
| Extend selection to the last cell in the worksheet |
Ctrl + Shift + End |
Command + Shift + End |
| Toggle extend selection mode |
F8 |
F8 |
Grid Operations Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Insert rows |
Ctrl + + |
Command + + |
| Delete rows |
Ctrl + – |
Command + – |
| Insert columns |
Ctrl + + |
Command + + |
| Delete columns |
Ctrl + – |
Command + – |
| Display Insert dialogue box |
Ctrl + Shift + + |
Command + Shift + + |
| Display Delete dialogue box |
Ctrl + – |
Command + – |
| Hide columns |
Ctrl + 0 |
Command + 0 |
| Unhide columns |
Ctrl + Shift + 0 |
Command + Shift + 0 |
| Hide rows |
Ctrl + 9 |
Command + 9 |
| Unhide rows |
Ctrl + Shift + 9 |
Command + Shift + 9 |
| Group rows or columns |
Alt + Shift + Right Arrow key |
Option + Shift + Right Arrow key |
| Ungroup rows or columns |
Alt + Shift + Left Arrow key |
Option + Shift + Left Arrow key |
| Zoom in |
Ctrl + Alt + + |
Command + Option + + |
| Zoom out |
Ctrl + Alt + – |
Command + Option + – |
| Open group dialogue box |
Alt + Shift + Right Arrow key |
Option + Shift + Right Arrow key |
| Open Ungroup dialogue box |
Alt + Shift + Left Arrow key |
Option + Shift + Left Arrow key |
| Hide or show outline symbols |
Ctrl + 8 |
Command + 8 |
| Delete cells |
Ctrl + – |
Command + – |
| Delete contents of selected cells |
Delete |
Delete |
Workbook Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Insert new worksheet |
Shift + F11 |
Shift + F11 |
| Go to the next worksheet |
Ctrl + Page Down key |
Command + Page Down key |
| Go to the previous worksheet |
Ctrl + Page Up key |
Command + Page Up key |
| Move to the next pane |
F6 |
F6 |
| Move to the previous pane |
Shift + F6 |
Shift + F6 |
| Go to the next workbook |
Ctrl + Tab |
Command + Tab |
| Go to the previous workbook |
Ctrl + Shift + Tab |
Command + Shift + Tab |
| Minimize the current workbook window |
Ctrl + F9 |
Command + F9 |
| Maximize current workbook window |
Ctrl + F10 |
Command + F10 |
| Select adjacent worksheets |
Shift + Click |
Shift + Click |
| Select non-adjacent worksheets |
Ctrl + Click |
Command + Click |
| Toggle scroll lock |
Scr Lk |
Scr Lk |
| Toggle fullscreen |
Ctrl + Shift + F1 |
Command + Shift + F1 |
Pivot Table Shortcuts
| Action |
Excel Shortcut keys Windows |
Excel Shortcut keys Mac |
| Select entire pivot tables |
Ctrl + A |
Command + A |
| Toggle pivot table field checkbox |
Spacebar |
Spacebar |
| Group pivot table items |
Alt + Shift + Right Arrow key |
Option + Shift + Right Arrow key |
| Ungroup pivot table items |
Alt + Shift + Left Arrow key |
Option + Shift + Left Arrow key |
| Hide pivot table item |
Ctrl + – |
Command + – |
| Create a pivot chart on the same worksheet |
Alt + F1 |
Option + F1 |
| Create a pivot chart on the new worksheet |
F11 |
F11 |
| Open pivot table wizard |
Alt, D, P |
Option, D, P |
Excel Formulas Shortcuts
These shortcuts allow you to enter and manipulate data within your worksheets, such as entering the same data in multiple cells at once, inserting the SUM function, or entering the current date or time. Examples include Ctrl + Enter (enter same data in multiple cells), Ctrl + Shift + = (insert SUM function), and Ctrl + ; (enter current date).
| Action |
Excel Shortcut keys Windows |
Excel Shortcut keys Mac |
| Autosum selected cells |
Alt + = |
Option + = |
| Toggle formulas on and off |
Ctrl + ` |
Command + ` |
| Insert function arguments |
Ctrl + Shift + A |
Command + Shift + A |
| Enter array formula |
Ctrl + Shift + Enter |
Command + Shift + Return |
| Calculate worksheets |
F9 |
F9 |
| Calculate active worksheet |
Shift + F9 |
Shift + F9 |
| Force calculates all worksheets |
Ctrl + Alt + F9 |
Command + Option + F9 |
| Evaluate part of a formula |
F9 |
F9 |
| Expand or collapse the formula bar |
Ctrl + Shift + U |
Command + Shift + U |
| Display function arguments dialogue box |
Ctrl + A |
Command + A |
| Define name |
Ctrl + F3 |
Command + F3 |
| Define name using row and column labels |
Ctrl + Shift + F3 |
Command + Shift + F3 |
| Paste the name into a formula |
F3 |
F3 |
| Accept function with autocomplete |
Tab |
Tab |
| Toggle absolute and relative references |
F4 |
F4 |
| Open the Insert function dialogue box |
Shift + F3 |
Shift + F3 |
Excel Select Special Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Display Go To dialog box |
Ctrl + G |
Command + G |
| Select cells with comments |
Ctrl + Shift + O |
Command + Shift + O |
| Select the current region around the active cell |
Ctrl + Shift + * |
Command + Shift + * |
| Select current region |
Ctrl + A |
Command + A |
| Select current array |
Ctrl + / |
Command + / |
| Select row differences |
Ctrl + \ |
Command + \ |
| Select column difference |
Ctrl + Shift + | |
Command + Shift + | |
| Select direct precedents |
Ctrl + [ |
Command + [ |
| Select direct dependents |
Ctrl + ] |
Command + ] |
| Select all precedents |
Ctrl + Shift + { |
Command + Shift + { |
| Select all dependents |
Ctrl + Shift + } |
Command + Shift + } |
| Select visible cells only |
Alt + ; |
Option + ; |
Table Shortcuts
| Action |
Excel Shortcuts Windows |
Excel Shortcuts Mac |
| Insert table |
Ctrl + T |
Command + T |
| Select table row |
Shift + Spacebar |
Shift + Spacebar |
| Select table column |
Ctrl + Spacebar |
Command + Spacebar |
| Select table |
Ctrl + A |
Command + A |
| Toggle table total row |
Ctrl + Shift + T |
Command + Shift + T |
| Move to the next field which can be edited |
Tab |
Tab |
| Move to the previous field which can be edited |
Shift + Tab |
Shift + Tab |
| Move to the first field in the next record |
Enter |
Return |
| Move to the first field in the previous record |
Shift + Enter |
Shift + Return |
| Move to the same field 10 records forward |
Page Down key |
Page Down key |
| Move to the same field 10 records back |
Page Up key |
Page Up key |
| Move to a new record |
Ctrl + Page Down key |
Command + Page Down key |
| Move to a first record |
Ctrl + Page Up key |
Command + Page Up key |
| Move to the beginning of a field |
Home key |
Home key |
| Move to the end of a field |
End key |
End key |
Microsoft Excel is one of the many data analytical tools available in the market. Despite the various data analytical tools in the market, excel still is the go-to product when it comes to working with data. If you don’t have that kind of money to spend on a subscription, then you can look for a free alternative i.e. Google Sheets. Consider taking a look at the Google Sheet Shortcuts list.
FAQs
How do I view a list of all Excel shortcut keys?
In Excel, you can view a list of all shortcut keys by going to File > Options > Customize ribbon and then selecting the Keyboard shortcuts button at the bottom of the window.
Can I create my own custom shortcut keys in Excel?
Yes, you can create your own custom shortcut keys in Excel by going to File > Options > Customize ribbon and then selecting the Keyboard shortcuts button at the bottom of the window. From there, you can choose a command from the Categories list and then assign a shortcut key to it.
Can I use the same shortcut keys in both Windows and Mac versions of Excel?
Some shortcut keys are the same in both Windows and Mac versions of Excel, such as Ctrl + C (copy) and Ctrl + V (paste). However, some shortcuts are specific to either the Windows or Mac version, so it's a good idea to familiarize yourself with the shortcuts for both platforms.
READ NEXT:
