Shared Flashcard Set

Details

Excel Keyboard Shortcuts
Become a more efficient user of Microsoft Excel with these keyboard shortcuts
102
Computer Science
11th Grade
03/21/2007
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
New file
 Definition
Ctrl+N
Term
Open file
 Definition
Ctrl+O
Term
Save file
 Definition
Ctrl+S
Term
Move between open workbooks
 Definition
Ctrl+F6
Term
Close file
 Definition
Ctrl+F4
Term
Save as
 Definition
F12
Term
Display print menu
 Definition
Ctrl+P
Term
Select a whole spreadsheet
 Definition
Ctrl+A
Term
Select column
 Definition
Ctrl+space
Term
Select row
 Definition
Shift+Space
Term
Undo last action
 Definition
Ctrl+Z
Term
Redo last action
 Definition
Ctrl+Y
Term
Start a formula
 Definition
Equals sign (eg. SUM(A1+A2)
Term
Exit Excel 97
 Definition
Alt+F4
Term
Move to next cell row
 Definition
Tab
Term
Move to previous cell in row
 Definition
Shift+Tab
Term
Up one screen
 Definition
Page Up
Term
Down one screen
 Definition
Page Down
Term
Move to next worksheet
 Definition
Ctrl+Page Down
Term
Move to previous worksheet
 Definition
Ctrl + Page Up
Term
Go to first cell in data region
 Definition
Ctrl + Home
Term
Go to last cell in data region
 Definition
Ctrl + End
Term
Bold toggle for selection
 Definition
Ctrl + B
Term
Italic toggle for selection
 Definition
Ctrl + I
Term
Underline toggle for selection
 Definition
Ctrl + U
Term
Strikethrough for selection
 Definition
Ctrl + 5
Term
Change the font
 Definition
Ctrl + Shift + F
Term
Change the font size
 Definition
Ctrl + Shift + P
Term
Apply outline borders
 Definition
Ctrl + Shift + 7
Term
Remove all borders
 Definition
Ctrl + Shift + Underline
Term
Wrap text in same cell
 Definition
Alt + Enter
Term
Format cells
 Definition
Ctrl + 1
Term
Select font
 Definition
Ctrl + Shift + F
Term
Select point size
 Definition
Ctrl + Shift + P
Term
Format as currency
 Definition
Ctrl + Shift + 4
Term
Format as general (to remove any formatting)
 Definition
Ctrl + Shift + # (hash sign)
Term
Format as percentage
 Definition
Ctrl + Shift + 5
Term
Format as number
 Definition
Ctrl + Shift + 1
Term
Delete one character to right
 Definition
Delete
Term
Delete one character to left
 Definition
Backspace
Term
Edit active cell
 Definition
F2
Term
Cancel cell entry
 Definition
Escape Key
Term
Select entire worksheet
 Definition
Ctrl + A
Term
Select entire row
 Definition
Shift + Spacebar
Term
Select entire column
 Definition
Ctrl + Spacebar
Term
Manual select
 Definition
Hold Shift + with Left, Right, Up, Down Arrow Key
Term
Autosum a range of cells
 Definition
Alt + Equals Sign
Term
Insert the date
 Definition
Ctrl + ; (semi-colon)
Term
Insert the time
 Definition
Ctrl + Shift + ; (semi-colon)
Term
Insert columns/rows
 Definition
Ctrl + Shift + + (plus sign)
Term
Insert a new worksheet
 Definition
Shift + F11
Term
Find text
 Definition
Ctrl + F
Term
Say Version of Excel
 Definition
Ctrl + Shift + V
Term
Replace text dialog
 Definition
Ctrl + H
Term
Create a chart automatically on new sheet
 Definition
F11
Term
Edit a cell comment
 Definition
Shift + F2
Term
Move to Next Sheet
 Definition
Ctrl + Page Down
Term
Move to Prior Sheet
 Definition
Ctrl + Page Up
Term
Go to a cell command
 Definition
Ctrl + G
Term
Collapse Selection To Active Cell
 Definition
Shift + Backspace
Term
Say Active Cell Coordinates
 Definition
Insert + C
Term
AutoSum
 Definition
Alt + Equals
Term
Formula Mode
 Definition
Equals Sign
Term
Insert Date In Current Cell
 Definition
Ctrl + ; (semicolon)
Term
Insert Time In Current Cell
 Definition
Ctrl + Shift + ; (semicolon)
Term
Current Column First Cell From Top
 Definition
Alt + 1
Term
Current Column Second Cell From Top
 Definition
Alt + 2
Term
Current Column Third Cell From Top
 Definition
Alt + 3
Term
Current Column Fourth Cell From Top
 Definition
Alt + 4
Term
Data Region Left
 Definition
Ctrl + Left Arrow
Term
Data Region Right
 Definition
Ctrl + Right Arrow
Term
Data Region Down
 Definition
Ctrl + Down Arrow
Term
Data Region Up
 Definition
Ctrl + Up Arrow
Term
Select Whole Data Region
 Definition
Ctrl + Shift + 8
Term
Say Formula
 Definition
Ctrl + F2
Term
Spell Check
 Definition
F7
Term
Report Gridline Status
 Definition
Alt + Shift + g
Term
Read Row Total
 Definition
Insert + Delete
Term
Read Column Total
 Definition
Insert + Delete
Term
Say Column Title
 Definition
Alt + Shift + C
Term
Say Row Title
 Definition
Alt + Shift + R
Term
Say Visible Range Coordinates
 Definition
Alt + Shift + V
Term
Cycle Through Controls in Dialog Box
 Definition
Tab
Term
Tab Backwards
 Definition
Shift + Tab
Term
List Cells With Comments
 Definition
Ctrl + Shift + ' (apostrophe)
Term
Row Second Cell From Left
 Definition
Alt + Ctrl + 2
Term
Row First Cell From Left
 Definition
Alt + Ctrl + 1
Term
Row Third Cell From Left
 Definition
Alt + Ctrl + 3
Term
Describe Cell Border
 Definition
Alt + Shift + B
Term
Read Cell Comment
 Definition
Alt + Shift + ' (apostrophe)
Term
Auto Filter
 Definition
Ctrl + Shift + A
Term
Read Cell Hyperlink
 Definition
Alt + Shift + H
Term
Close Office Assistant
 Definition
Ctrl + Insert + F4
Term
Set Monitor Cell One
 Definition
Alt + Ctrl + Shift + 1
Term
Set Monitor Cell Two
 Definition
Alt + Ctrl + Shift + 2
Term
Set Monitor Cell Three
 Definition
Alt + Ctrl + Shift + 3
Term
Set Monitor Cell Four
 Definition
Alt + Ctrl + Shift + 4
Term
Set Monitor Cell Five
 Definition
Alt + Ctrl + Shift + 5
Term
Set Monitor Cell Six
 Definition
Alt + Ctrl + Shift + 6
Term
Set Monitor Cell Six
 Definition
Alt + Ctrl + Shift + 6
Term
Set Monitor Cell Seven
 Definition
Alt + Ctrl + Shift + 7
Term
Set Monitor Cell Eight
 Definition
Alt + Ctrl + Shift + 8
Supporting users have an ad free experience!