| 
More useful keyboard
  shortcuts in Excel 2010 Key combination  | 
Action  | 
| 
Worksheet navigation  | |
| 
PgUp / PgDn  | 
Move one screen up / down  | 
| 
Alt-PgUp / Alt-PgDn  | 
Move one screen to the left /
  right  | 
| 
Ctrl-PgUp / Ctrl-PgDn  | 
Move one worksheet tab to the
  left / right  | 
| 
Tab  | 
Move to the next cell to the
  right  | 
| 
Shift-Tab  | 
Move to the cell to the left  | 
| 
Home  | 
Move to the beginning of a
  row  | 
| 
Ctrl-Home  | 
Move to the beginning of a
  worksheet  | 
| 
Ctrl-End  | 
Move to the last cell that has
  content in it  | 
| 
Ctrl-Left arrow  | 
Move to the word to the left
  while in a cell  | 
| 
Ctrl-Right arrow  | 
Move to the word to the right
  while in a cell  | 
| 
Ctrl-G or F5  | 
Display the Go To dialog box  | 
| 
F6  | 
Switch between the worksheet,
  the Ribbon, the task pane and Zoom controls  | 
| 
Ctrl-F6  | 
If more than one worksheet is
  open, switch to the next one  | 
| 
Working with data  | |
| 
Shift-Spacebar  | 
Select a row  | 
| 
Ctrl-Spacebar  | 
Select a column  | 
| 
Ctrl-A or Ctrl-Shift-Spacebar
   | 
Select an entire worksheet  | 
| 
Shift-Arrow key  | 
Extend selection by a single
  cell  | 
| 
Shift-PgDn / Shift-PgUp  | 
Extend selection down one
  screen / up one screen  | 
| 
Shift-Home  | 
Extend selection to the
  beginning of a row  | 
| 
Ctrl-Shift-Home  | 
Extend selection to the
  beginning of the worksheet  | 
| 
Ctrl-C  | 
Copy cell's contents to the
  clipboard  | 
| 
Ctrl-X  | 
Copy and delete cell's
  contents  | 
| 
Ctrl-V  | 
Paste from the clipboard into
  a cell  | 
| 
Ctrl-Alt-V  | 
Display the Paste Special
  dialog box  | 
| 
Enter  | 
Finish entering data in a
  cell and move to the next cell down  | 
| 
Shift-Enter  | 
Finish entering data in a
  cell and move to the next cell up  | 
| 
Esc  | 
Cancel your entry in a cell  | 
| 
Ctrl-;  | 
Insert the current date  | 
| 
Ctrl-Shift-;  | 
Insert the current time  | 
| 
Ctrl-K  | 
Insert a hyperlink  | 
Topic Search
 
  
    Custom Search
  
Thursday, September 11, 2014
useful keyboard shortcuts in Excel 2010
Subscribe to:
Comments (Atom)
 
