F2
|
Edit the selected
cell
|
F3
|
After a name has
been created F3 will paste names
|
F5
|
Go to a specific
cell. For example, C6
|
F7
|
Spell check selected
text or document
|
F11
|
Create chart from
selected data
|
Ctrl + Shift + ;
|
Enter the current
time
|
Ctrl + ;
|
Enter the current
date
|
Alt + Shift + F1
|
Insert new worksheet
|
Shift + F3
|
Open the Excel
formula window
|
Shift + F5
|
Bring up search box
|
Ctrl + A
|
Select all contents
of the worksheet
|
Ctrl + B
|
Bold highlighted
section
|
Ctrl + I
|
Italic highlighted
section
|
Ctrl + K
|
Insert link
|
Ctrl + U
|
Underline
highlighted section
|
Ctrl + 1
|
Change the format of
selected cells
|
Ctrl + 5
|
Strike through
highlighted section
|
Ctrl + P
|
Bring up the print
dialogue box to begin printing
|
Ctrl + Z
|
Undo last action
|
Ctrl + F3
|
Open Excel Name
Manager
|
Ctrl + F9
|
Minimize current
window
|
Ctrl + F10
|
Maximize currently
selected window
|
Ctrl + F6
|
Switch between open
work books or windows
|
Ctrl + Page up
|
Move between Excel
work sheets in the same Excel document
|
Ctrl + page down
|
Move between Excel
worksheets in the same Excel document
|
Ctrl + Tab
|
Move between two or
more open Excel document
|
Alt + =
|
Create a formula to
sum all of the above cells
|
Ctrl + ’
|
Insert the value of
the above cell into cell currently selected
|
Ctrl + Shift + !
|
Format number in
comma format
|
Ctrl + Shift + $
|
Format number in
currency format
|
Ctrl + Shift + #
|
Format number in
date format
|
Ctrl + Shift + %
|
Format number in
percentage format
|
Ctrl + Shift + ^
|
Format number in
scientific format
|
Ctrl + Shift + @
|
Format number in
time format
|
Ctrl + Arrow key
|
Move to the next
selection on text
|
Ctrl + Space
|
Select entire column
|
Shift + Space
|
Select entire row
|
Ctrl + -
|
Delete the selected
column or row
|
Ctrl + shift + =
|
Insert a new column
or row
|
Ctrl + Home
|
Move to cell A1
|
Ctrl + ~
|
Switch between
showing Excel formulas or their values in cells
|
