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
[sc_fs_multi_faq headline-0=”h2″ question-0=”Is Excel Web free?” answer-0=”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.” image-0=”” headline-1=”h2″ question-1=”Does Excel Web have all the features of the desktop version of Excel?” answer-1=”Excel Web has most of the features found in the desktop version, but there may be some differences and limitations in functionality.” image-1=”” headline-2=”h2″ question-2=”Can I use Excel Web offline?” answer-2=”No, Excel Web requires an internet connection to be used.” image-2=”” headline-3=”h2″ question-3=”Can I use Excel Web with other Microsoft Office apps?” answer-3=”Yes, Excel Web can be used in conjunction with other Microsoft Office web apps, such as Word and PowerPoint.” image-3=”” count=”4″ html=”true” css_class=””]
READ NEXT: