Excel shortcuts

Excel shortcuts

16:09



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 + ; (semi­colon)
Insert the time
Ctrl + Shift + ; (semi­colon)
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


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


You Might Also Like

0 comments