Excel shortcuts
SHORTCUT KEYS
FOR EXCEL
|
Apply outline borders
|
Ctrl + Shift + 7
|
|
Auto Filter
|
Ctrl + Shift + A
|
|
AutoSum
|
Alt + Equals
|
|
Autosum a range of cells
|
Alt + Equals Sign
|
|
Bold toggle for selection
|
Ctrl + B
|
|
Cancel cell entry
|
Escape Key
|
|
Change the font
|
Ctrl + Shift + F
|
|
Change the font size
|
Ctrl + Shift + P
|
|
Close file
|
Ctrl + F4
|
|
Close Office Assistant
|
Ctrl + Insert + F4
|
|
Collapse Selection To Active Cell
|
Shift + Backspace
|
|
Copy
|
Ctrl + C
|
|
Copying and Moving Text
|
|
|
Create a chart automatically on new
sheet
|
F11
|
|
Current Column First Cell From Top
|
Alt + 1
|
|
Current Column Fourth Cell From Top
|
Alt + 4
|
|
Current Column Second Cell From Top
|
Alt + 2
|
|
Current Column Third Cell From Top
|
Alt + 3
|
|
Cut
|
Ctrl + X
|
|
Cycle Through Controls in Dialog
Box
|
Tab
|
|
Data Region Down
|
Ctrl + Down Arrow
|
|
Data Region Left
|
Ctrl + Left Arrow
|
|
Data Region Right
|
Ctrl + Right Arrow
|
|
Data Region Up
|
Ctrl + Up Arrow
|
|
Delete one character to left
|
Backspace
|
|
Delete one character to right
|
Delete
|
|
Describe Cell Border
|
Alt + Shift + B
|
|
Description
|
Shortcut Key
|
|
Description
|
Shortcut Key
|
|
Display the print menu
|
Ctrl + P
|
|
Down one screen
|
Page Down
|
|
Edit a cell comment
|
Shift + F2
|
|
Edit active cell
|
F2
|
|
Editing/Deleting Text
|
|
|
Exit Excel 97
|
Alt + F4
|
|
Find text
|
Ctrl + F
|
|
Format as currency
|
Ctrl + Shift + 4
|
|
Format as general (to remove any
formatting)
|
Ctrl + Shift + # (hash sign)
|
|
Format as number
|
Ctrl + Shift + 1
|
|
Format as percentage
|
Ctrl + Shift + 5
|
|
Format cells
|
Ctrl + 1
|
|
Formatting Cells
|
|
|
Formatting Text In Worksheet
|
|
|
Formula Mode
|
Equals Sign
|
|
General
|
|
|
Go to a cell command
|
Ctrl + G
|
|
Go to first cell in data region
|
Ctrl + Home
|
|
Go to last cell in data region
|
Ctrl + End
|
|
Highlighting Cells
|
|
|
Insert a new worksheet
|
Shift + F11
|
|
Insert columns/rows
|
Ctrl + Shift + + (plus sign)
|
|
Insert Date In Current Cell
|
Ctrl + ; (semicolon)
|
|
Insert the date
|
Ctrl + ; (semicolon)
|
|
Insert the time
|
Ctrl + Shift + ; (semicolon)
|
|
Insert Time In Current Cell
|
Ctrl + Shift + ; (semicolon)
|
|
Inserting Text Automatically
|
|
|
Italic toggle for selection
|
Ctrl + I
|
|
List Cells At Page Breaks
|
Ctrl + Shift + B
|
|
List Cells With Comments
|
Ctrl + Shift + ' (apostrophe)
|
|
List Data In Current Row
|
Ctrl + Shift + R
|
|
List Visible Cells With Data
|
Ctrl + Shift + D
|
|
Lists Data In Current Column
|
Ctrl + Shift + C
|
|
Main Jaws Keystrokes In Excel
|
|
|
Manual select
|
Hold Shift + with Left, Right, Up,
Down Arrow
|
|
Microsoft Excel Keyboard Keys
|
|
|
Misc
|
|
|
Move between open workbooks
|
Ctrl + F6
|
|
Move To Monitor Cell
|
Ctrl + Shift + M
|
|
Move to next cell in row
|
Tab
|
|
Move to Next Sheet
|
Ctrl + Page Down
|
|
Move to next worksheet
|
Ctrl + Page Down
|
|
Move to previous cell in row
|
Shift + Tab
|
|
Move to previous worksheet
|
Ctrl + Page Up
|
|
Move to Prior Sheet
|
Ctrl + Page Up
|
|
Move To Worksheet Listbox
|
Ctrl + Shift + S
|
|
Navigating
|
|
|
New file
|
Ctrl + N
|
|
Open file
|
Ctrl + O
|
|
Options Listbox
|
Insert + V
|
|
Paste
|
Ctrl + V
|
|
Read Cell Comment
|
Alt + Shift + ' (apostrophe)
|
|
Read Cell Hyperlink
|
Alt + Shift + H
|
|
Read Column Total
|
Insert + Enter
|
|
Read Monitor Cell Eight
|
Alt + Shift + 8
|
|
Read Monitor Cell Five
|
Alt + Shift + 5
|
|
Read Monitor Cell Four
|
Alt + Shift + 4
|
|
Read Monitor Cell Nine
|
Alt + Shift + 9
|
|
Read Monitor Cell One
|
Alt + Shift + 1
|
|
Read Monitor Cell Seven
|
Alt + Shift + 7
|
|
Read Monitor Cell Six
|
Alt + Shift + 6
|
|
Read Monitor Cell Ten
|
Alt + Shift + 0
|
|
Read Monitor Cell Three
|
Alt + Shift + 3
|
|
Read Monitor Cell Two
|
Alt + Shift + 2
|
|
Read Row Total
|
Insert + Delete
|
|
Redo last action
|
Ctrl + Y
|
|
Remove all borders
|
Ctrl + Shift + Underline
|
|
Replace text dialog
|
Ctrl + H
|
|
Report Gridline Status
|
Alt + Shift + g
|
|
Row First Cell From Left
|
Alt + Ctrl + 1
|
|
Row Fourth Cell From Left
|
Alt + Ctrl + 4
|
|
Row Second Cell From Left
|
Alt + Ctrl + 2
|
|
Row Third Cell From Left
|
Alt + Ctrl + 3
|
|
Save as
|
F12
|
|
Save file
|
Ctrl + S
|
|
Say Active Cell Coordinates
|
Insert + C
|
|
Say Column Title
|
Alt + Shift + C
|
|
Say Formula
|
Ctrl + F2
|
|
Say Row Title
|
Alt + Shift + R
|
|
Say Version of Excel
|
Ctrl + Shift + V
|
|
Say Visible Range Coordinates
|
Alt + Shift + V
|
|
Select column
|
Ctrl + Space
|
|
Select entire column
|
Ctrl + Spacebar
|
|
Select entire row
|
Shift + Spacebar
|
|
Select entire worksheet
|
Ctrl + A
|
|
Select font
|
Ctrl + Shift + F
|
|
Select Hyperlink
|
Ctrl + Shift + H
|
|
Select point size
|
Ctrl + Shift + P
|
|
Select row
|
Shift + Space
|
|
Select Whole Data Region
|
Ctrl + Shift + 8
|
|
Select whole spreadsheet
|
Ctrl + A
|
|
Select Worksheet Objects
|
Ctrl + Shift + O
|
|
Set Monitor Cell 10
|
Alt + Ctrl + Shift + 0
|
|
Set Monitor Cell Eight
|
Alt + Ctrl + Shift + 8
|
|
Set Monitor Cell Five
|
Alt + Ctrl + Shift + 5
|
|
Set Monitor Cell Four
|
Alt + Ctrl + Shift + 4
|
|
Set Monitor Cell Nine
|
Alt + Ctrl + Shift + 9
|
|
Set Monitor Cell One
|
Alt + Ctrl + Shift + 1
|
|
Set Monitor Cell Seven
|
Alt + Ctrl + Shift + 7
|
|
Set Monitor Cell Six
|
Alt + Ctrl + Shift + 6
|
|
Set Monitor Cell Three
|
Alt + Ctrl + Shift + 3
|
|
Set Monitor Cell Two
|
Alt + Ctrl + Shift + 2
|
|
Spell Check
|
F7
|
|
Start a formula
|
Equals Sign (eg. SUM(A1+A2)
|
|
Strikethrough for selection
|
Ctrl + 5
|
|
Tab Backwards
|
Shift + Tab
|
|
Underline toggle for selection
|
Ctrl + U
|
|
Undo last action
|
Ctrl + Z
|
|
Up one screen
|
Page Up
|
|
Wrap text in same cell
|
Alt + Enter
|
CLICK HERE FOR UPDATES
DISCLAMER
DISCLAMER
All information provided in www.edujobnews.com is provided for information purposes only and does not constitute a legal contract and makes no guarantees of any kind. All information contained on this site is intended for general educational, informational and helpful purposes only so admin@edujobnews is not responsible for these.for contact admin@edujobnews.com
Leave a Comment