Microsoft EXCEL Shortcut keys
Select
Multiple Cells
Click
n Drag
Click Shift Click
Ctrl Arrows
Shift Arrows
Select Random Cells
Ctrl Click
Insert Column/Row
Select Column/Row Press
Ctrl +
Delete Column/Row
Select
Column/Row Press Ctrl -
Navigating
Around
Ctrl Home
to get to cell A1
Ctrl End to get to the last column or row where there
is some data
F5 to Go to a Specific cell (range of cells use :
)
Ctrl Arrows jumps to a cell where there is a blank
cell above/below/left/right (depends on which arrows you pressed)
Edit
Data in a Cell
F2
Double click in a cell
Click in Formula Bar
Close a Window
Ctrl W
Reveal Functions in
a sheet
Ctrl ~
Excel
Shortcut keys Printable format
|
Microsoft WORD Shortcut keys
Navigating
around
Ctrl Home -Top
of document
Ctrl End - End of document
Ctrl Pgup-Down to Jump 1 pg at a time
Selecting Text
D- Click Select 1 word
Triple Click Selects a Paragraph
Ctrl Click Selects a Sentence
Line Spacing
Ctr 1 -
Single
Ctrl 2 - Double
Ctrl 5 - One and a half
Characters
Shift F3
- Toggles between Uppercase, Lower Case and Title Case.
Ctrl Shift = SuperScript
Ctrl = SubScript
Ctrl L alignment Left
Ctrl R alignment Right
Ctrl E alignment Centre
Insert
=== Enter
Double Line
--- Enter Single Line
~~~ Enter Wavey Line
* Tab Starts Bullets
1 Tab Starts numbering
Breaks
Ctrl Enter
Insert a pageBreak
Word
Shortcut keys printable format
|
