Keyboard shortcuts
in Excel Online
The keyboard shortcuts that are described in this Help topic
refer to the U.S. keyboard layout. Keys on other layouts might not correspond
exactly to the keys on a U.S. keyboard.
Tips:
·
Excel
Online runs in your web browser so the keyboard shortcuts are different than
those in the Excel desktop program. For example, you'll use Ctrl+F6 instead of
F6 for jumping in and out of the commands. Also, common shortcuts like F1 and
Ctrl+P apply to the web browser, not Excel Online.
·
As
a shortcut to commands, press Ctrl+' (apostrophe) to jump to Tell Me,
and then type the command you want (available only in Editing view). Use the Up
and Down arrows to select a command, and then press Enter.
·
To
jump to a particular cell, use the Go To command: press
Ctrl+G, type the cell reference (such as B14), and then press Enter.
Excel Online
commands
|
To
do this
|
Press
|
|
Move
between ribbon and workbook content
|
Ctrl+F6
|
|
Activate
a different ribbon tab
|
Tab
and then Enter
|
|
Move
among ribbon commands
|
Tab
|
|
Execute
the currently selected ribbon command
|
Enter
|
Work with worksheets
|
To
do this
|
Press
|
|
Find
|
Ctrl+F,
or Shift+F5
|
|
Repeat
Find down
|
Shift+F4
|
|
Repeat
Find up
|
Ctrl+Shift+F4
|
Move and scroll
within worksheets
|
To
do this
|
Press
|
|
Up
one cell
|
Up
Arrow, or Shift+Enter
|
|
Down
one cell
|
Down
Arrow, or Enter
|
|
Right
one cell
|
Right
Arrow, or Tab
|
|
Left
one cell
|
Left
Arrow, or Shift+Tab
|
|
Beginning
of the row
|
Home
|
|
Go
to A1
|
Ctrl+Home
|
|
Last
cell of used range
|
Ctrl+End
|
|
Move
down one screen
|
Page
Down
|
|
Move
up one block of rows
|
Page
Up
|
Work with objects
|
To
do this
|
Press
|
|
Open
menu/Drill down
|
Alt+Down
Arrow
|
|
Drill
up
|
Alt+Up
Arrow
|
|
Follow
hyperlink
|
Ctrl+Enter
|
|
Open
Comment pane
|
Shift+F2
|
Select cells, rows
and columns, and objects
|
To
do this
|
Press
|
|
Range
of cells
|
Shift+Arrow
keys
|
|
Entire
column
|
Ctrl+SPACE
|
|
Entire
row
|
Shift+SPACE
|
|
To
beginning of row
|
Shift+Home
|
|
Up
block of cells in current column
|
Shift+Page
Up
|
|
Down
block of cells in current column
|
Shift+Page
Down
|
Move within a
selected range
|
To
do this
|
Press
|
|
From
top to bottom (or forward through selection)
|
Enter
|
|
From
bottom to top (or back through selection)
|
Shift+Enter
|
|
Forward
through a row (or down through a single-column selection)
|
Tab
|
|
Back
through a row (or up through a single-column selection)
|
Shift+Tab
|
Calculate data
|
To
do this
|
Press
|
|
Calculate
workbook (refresh)
|
F9
|
|
Full
calculate
|
Ctrl+Shift+Alt+F9
|
Refresh external
data
|
To
do this
|
Press
|
|
Refresh
|
Alt+F5
|
|
Refresh
all
|
Ctrl+Alt+F5
|
Edit cells
|
To
do this
|
Press
|
|
Cut
|
Ctrl+X
|
|
Copy
|
Ctrl+C
|
|
Paste
|
Ctrl+V
|
|
Undo
|
Ctrl+Z
|
|
Redo
|
Ctrl+Y
|
Enter data
|
To
do this
|
Press
|
|
Complete
cell entry and select the cell below
|
Enter
|
|
Complete
cell entry and select the cell above
|
Shift+Enter
|
|
Complete
cell entry and select the next cell in the row
|
Tab
|
|
Complete
cell entry and select the previous cell in the row
|
Shift+Tab
|
|
Cancel
cell entry
|
Esc
|
|
Start
a new line in the same cell
|
Alt+Enter
|
|
Insert
hyperlink
|
Ctrl+K
|
|
Insert
Table
|
Ctrl+L
|
Edit data within a
cell
|
To
do this
|
Press
|
|
Edit
selected cell
|
F2
|
|
Clear
selected cell
|
Delete
|
|
Clear
selected cell and start editing
|
Backspace
|
|
Move
right one character
|
Right
Arrow
|
|
Move
left one character
|
Left
Arrow
|
|
Move
right one word
|
Ctrl+Right
Arrow
|
|
Move
left one word
|
Ctrl+Left
Arrow
|
|
Go
to beginning of cell data
|
Home
|
|
Go
to end of cell data
|
End
|
|
Select
right by character
|
Shift+Right
Arrow
|
|
Select
left by character
|
Shift+Left
Arrow
|
|
Select
right by word
|
Shift+Ctrl+Right
Arrow
|
|
Select
left by word
|
Shift+Ctrl+Left
Arrow
|
|
Select
to beginning of cell data
|
Shift+Home
|
|
Select
to end of cell data
|
Shift+End
|
|
Copy
|
Ctrl+C
|
|
Cut
|
Ctrl+X
|
|
Paste
|
Ctrl+V
|
Format cells
|
To
do this
|
Press
|
|
Bold
|
Ctrl+B
|
|
Italics
|
Ctrl+I
|
|
Underline
|
Ctrl+U
|
M S I Khan (sofiq)