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 |
No comments:
Post a Comment