ProductivityShortcutsWeb Application

105 Excel for the Web Keyboard Shortcuts

Download Excel for the web Shortcuts PDF

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:

Devil

Hello, my name is Pratik, and I am the founder of Tutorial Tactic. Mistakes are essential for learning, and Tutorial Tactic is here to help you stand strong, learn even more, and achieve success!
Back to top button