EXCEL
FUNCTION KEYS
ALT
CTRL
SHIFT
100
this key allows you to unhide any hidden rows within the selection
What is CTRL+SHIFT+(
100
displays the excel help task pane
What is F1
100
creates an embedded chart of the data in the current range
What is ALT+F1
100
selects an entire column in a worksheet
What is CTRL+SPACEBAR
100
copies the value from the cells above the active cell into the cell or the formula bar
What is CTRL+SHIFT+"
200
this key allows you to apply the outline border to the selected cells
What is CTRL+SHIFT+&
200
displays or hide the ribbon
What is ctrl+F1
200
closes excel
What is ALT+F4
200
selects the current and previous sheet in a workbook
What is CTRL+SHIFT+PAGE UP
200
Displays the insert dialog box to insert blank cells
What is CTRL+SHIFT+(+)
300
removes the outline border from the selected cells
What is CTRL+SHIFT_
300
creates an embedded chart of the data in the current range
What is alt+F1
300
displays the macro dialog box to create,run,edit,or delete at macro
What is ALT+F8
300
moves to the next sheet in a workbook
What is CTRL+PAGE DOWN
300
inserts the arguement names and parenthese when the insertion point is to the right of a function name in a formula
What is CTRL+SHIFT+A
400
applies the general number format
What is ctrl+shift+~
400
inserts a new worksheet
What is ALT+SHIFT+F1
400
opens the microsoft visual basic for applications editor,in which you can create a macro by using visual basic for applications
What is ALT+F11
400
fills the selected cell range with the current entry
What is CTRL+ENTER
400
opens the format cells dialog box with the font tab selected
What is CTRL+SHIFT+F
500
applies the currency format with two decimal places(negative numbers in percentages)
What is ctrl+shift+$
500
adds or edits a cell comment
What is shift+F2
500
starts a new line in the same cell
What is ALT+ENTER
500
moves to the beginning of a worksheet
What is CTRL+HOME
500
selects all cells that contain comments
What is CTRL+SHIFT+O
M
e
n
u