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:
Posts (Atom)