Topic Search

Custom Search

Thursday, September 11, 2014

useful keyboard shortcuts in Excel 2010




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