Monday, February 25, 2013

Microsoft Excel Web App Keyboard shortcuts

Here is the list of keyboard shortcuts for Microsoft Excel Web app for U.S. keyboard layout.

Excel Web App commands
TO DO THIS
PRESS

Move between ribbon and workbook content
Ctrl+F6
Activate a different ribbon tab
Tab, Enter
Move among ribbon commands
Tab
Execute the currently selected ribbon command
Enter
Work with worksheets
TO DO THIS
PRESS
Switch to previous sheet
Ctrl+PgUp
Switch to next sheet
Ctrl+PgDn
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

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+T, or 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

0 comments

Post a Comment