Learn Excel for the web Shortcuts for Windows
Editing Shortcuts
| Action |
Excel for the web Shortcuts |
| Group data |
Alt + Shift + Right Arrow key |
| Ungroup data |
Alt + Shift + Left Arrow key |
| Paste Plain Text |
Ctrl + Shift + V |
| Move Viewport To Active Cell |
Ctrl + Backspace |
| Insert new sheet |
Shift + F11 |
| Refresh |
Alt + F5 |
| Refresh All |
Ctrl + Alt + F5 |
| Apply Auto Sum |
Alt + = |
| Increase font size |
Ctrl + Shift + . |
| Decrease font size |
Ctrl + Shift + , |
| Full calculate |
Ctrl + Alt + Shift + F9 |
| Cut |
Ctrl + X |
| Copy |
Ctrl + C |
| Paste |
Ctrl + V |
| Fill Down |
Ctrl + D |
| Fill Right |
Ctrl + R |
| Insert Function |
Shift + F3 |
| Insert hyperlink |
Ctrl + K |
| Redo the last action |
Ctrl + Y |
| Undo |
Ctrl + Z |
| Start a line in the same cell |
Alt + Enter |
| Complete the cell entry and select the cell above |
Shift + Enter |
| Insert table |
Ctrl + L |
| Read the row from the active cell |
Delete |
| Move to the Tell me box |
F2 |
| Read the row until the active cell |
F9 |
| Cancel cell entry |
Esc |
| Complete the cell entry and select the cell below |
Enter |
| Clear selected cells and start editing |
Backspace |
Navigation Shortcuts
| Action |
Excel for the web Shortcuts |
| Move to the edge of the current data region |
Ctrl + Arrow keys |
| Move to the previous cell or command |
Left Arrow key |
| Go to the last cell of the used range |
Ctrl + End |
| Go to cell A1 |
Ctrl + Home |
| Drill up |
Alt + Up Arrow key |
| Open a filter menu when a table cell is selected |
Alt + Shift + Down Arrow key |
| Open a filter menu or drill down |
Alt + Down Arrow key |
| Go to a specific cell |
Ctrl + G |
| Repeat Find, upward |
Ctrl + Shift + F4 |
| Repeat Find, downward |
Shift + F4 |
| Find |
Ctrl + F |
| Find and Replace |
Ctrl + H |
| Switch to the next sheet |
Ctrl + Alt + Page Down key |
| Switch to the previous sheet |
Ctrl + Alt + Page Up key |
| Move down one cell |
Down Arrow key |
| Move right one cell |
Right Arrow key |
| Move up one cell |
Up Arrow key |
| Go to the beginning of the cell line |
Home |
| Move down one screen (28 rows) |
Page Down key |
| Move up one screen (28 rows) |
Page Up key |
Objects Shortcuts
| Action |
Excel for the web Shortcuts |
| Rotate a shape or a picture to the left |
Ctrl + Alt + Left Arrow key |
| Rotate a shape or a picture to the right |
Ctrl + Alt + Right Arrow key |
| Insert Chart |
Alt + F1 |
| Follow Hyperlink |
Ctrl + Enter |
Review Shortcuts
| Action |
Excel for the web Shortcuts |
| Insert comment |
Shift + F2 |
| Spell check |
Ctrl + F7 |
View Shortcuts
| Action |
Excel for the web Shortcuts |
| Flash Fill |
Ctrl + E |
| Insert Cells |
Ctrl + = |
| Delete Cells |
Ctrl + – |
| Hide columns |
Ctrl + 0 |
| Hide rows |
Ctrl + 9 |
| Turn on filtering for the selected cell |
Ctrl + Shift + L |
| Show the field list for a linked data type |
Alt + Shift + F10 |
| Show the card for a linked data type |
Ctrl + Shift + F5 |
| Expand a collapsed group of cells |
Alt + Shift + = |
| Collapse a group of cells |
Alt + Shift + – |
| Unhide columns |
Ctrl + Shift + 0 |
| Unhide rows |
Ctrl + Shift + 9 |
| Show/hide ribbon |
Ctrl + F1 |
| Reapply Filter |
Ctrl + Alt + L |
Selection Shortcuts
| Action |
Excel for the web Shortcuts |
| Extend selection to the last nonblank cell in the same column or row |
Ctrl + Shift + Arrow keys |
| Select an entire row |
Shift + Spacebar |
| Select all cells in the current region or sheet |
Ctrl + A |
| Select an entire column |
Ctrl + Spacebar |
| Extend selection down one screen (28 rows) |
Shift + Page Down key |
| Extend selection up one screen (28 rows) |
Shift + Page Up key |
| Extend selection to the beginning of the cell data |
Shift + Home |
| Select a range of cells |
Shift + Arrow keys |
Formatting Shortcuts
| Action |
Excel web Shortcuts |
| Apply an outline border |
Ctrl + Shift + 7 |
| Apply strikethrough |
Ctrl + 5 |
| Italics |
Ctrl + I |
| Underline |
Ctrl + U |
| Bold |
Ctrl + B |
File Commands Shortcuts
| Action |
Excel web Shortcuts |
| Open |
Ctrl + O |
| Save as |
Alt + F2 |
| Print |
Ctrl + P |
Accessibility Shortcuts
| Action |
Excel web Shortcuts |
| Open context menu |
Shift + F10 |
| Open shortcuts dialog |
Alt + Shift + A |
| Read column header |
Ctrl + Alt + Shift + H |
| Read row header |
Ctrl + Alt + Shift + T |
| Read column until active cell |
Ctrl + Alt + Shift + Page Up key |
| Read the column from the active cell |
Ctrl + Alt + Shift + Page Down key |
| Read the row until the active cell |
Ctrl + Alt + Shift + Home |
| Read the row from the active cell |
Ctrl + Alt + Shift + End |
| Move to the Tell me box |
Alt + Win then Q |
| Open the File tab |
Alt + Win then F |
| Open the Home tab |
Alt + Win then H |
| Open the Insert tab |
Alt + Win then N |
| Open the Data tab |
Alt + Win then A |
| Open the Review tab |
Alt + Win then R |
| Open the View tab |
Alt + Win then W |
| Open the file in the Excel app |
Alt + Win then O |
| Display or hide Key Tips |
Alt + Win |
| Access a dialog menu to move or size it |
Ctrl + Alt + Spacebar |
| Move Left one cell |
Left Arrow key |
| Move between the cells, sheet tabs |
Ctrl + F6 |
FAQs
Is Excel Web free?
Excel Web is a part of Microsoft's Office 365 subscription service and requires a paid subscription to access. However, Microsoft offers a free trial for Office 365.
Does Excel Web have all the features of the desktop version of Excel?
Excel Web has most of the features found in the desktop version, but there may be some differences and limitations in functionality.
Can I use Excel Web offline?
No, Excel Web requires an internet connection to be used.
Can I use Excel Web with other Microsoft Office apps?
Yes, Excel Web can be used in conjunction with other Microsoft Office web apps, such as Word and PowerPoint.
READ NEXT:
