Shared Flashcard Set

Details

Excel
Keyboard Shortcuts
127
Computer Science
11th Grade
03/21/2007

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 The Print Menu
Definition
CTRL+P
Term
Select Whole Spreadsheet
Definition
CTRL+A
Term
Select Column
Definition
CTRL+Space
Term
Select Row
Definition
Shift+Space
Term
Undo Last Section
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
Shift+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
Cut
Definition
Ctrl + X
Term
Copy
Definition
Ctrl + C
Term
Paste
Definition
Ctrl + V
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
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
Say Version of Excel
Definition
Ctrl + Shift + V
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 + Enter
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
Row Fourth Cell From Left
Definition
Alt + Ctrl + 4
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
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 Seven
Definition
Alt + Ctrl + Shift + 7
Term
Set Monitor Cell Eight
Definition
Alt + Ctrl + Shift + 8
Term
Set Monitor Cell Nine
Definition
Alt + Ctrl + Shift + 9
Term
Set Monitor Cell Ten
Definition
Alt + Ctrl + Shift + 0
Term
Read Monitor Cell One
Definition
Alt + Shift + 1
Term
Read Monitor Cell Two
Definition
Alt + Shift + 2
Term
Read Monitor Cell Three
Definition
Alt + Shift + 3
Term
Read Monitor Cell Four
Definition
Alt + Shift + 4
Term
Read Monitor Cell Five
Definition
Alt + Shift + 5
Term
Read Monitor Cell Six
Definition
Alt + Shift + 6
Term
Read Monitor Cell Seven
Definition
Alt + Shift + 7
Term
Read Monitor Cell Eight
Definition
Alt + Shift + 8
Term
Read Monitor Cell Nine
Definition
Alt + Shift + 9
Term
Read Monitor Cell Ten
Definition
Alt + Shift + 0
Term
List Visible Cells With Data
Definition
Ctrl + Shift + D
Term
Lists Data In Current Column
Definition
Ctrl + Shift + C
Term
List Data In Current Row
Definition
Ctrl + Shift + R
Term
Select Hyperlink
Definition
Ctrl + Shift + H
Term
Move To Worksheet Listbox
Definition
Ctrl + Shift + S
Term
Move To Monitor Cell
Definition
Ctrl + Shift + M
Term
Select Worksheet Objects
Definition
Ctrl + Shift + O
Term
List Cells At Page Breaks
Definition
Ctrl + Shift + B
Term
Options Listbox
Definition
Insert + V
Supporting users have an ad free experience!