Shared Flashcard Set

Details

Excel
Keyboard Shortcuts
126
Computer Science
12th Grade
03/20/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 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 action
 Definition
Ctrl + Z
Term
Redo last action
 Definition
Ctrl + Y
Term
Start a formula
 Definition
Equal sign(eg. SUM(A1+A2)
Term
Exit excel 97
 Definition
Alt + F4
Term
Move to next cell in 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 + l
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 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
save 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
save 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 + ;(semi-colon)
Term
insert time in current cell
 Definition
ctrl + shift + ;(semi-colon)
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 foruth 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
save 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
save column title
 Definition
alt + shift + c
Term
save row title
 Definition
alt + shift + r
Term
save visible range coordinates
 Definition
akt + 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
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
list 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 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
Term
move to worksheet listbox
 Definition
ctrl + shift + s
Supporting users have an ad free experience!