Wednesday, May 21, 2014
Microsoft
Excel Most Important Shortcut Key
Excel
Shortcut Keys
|
Description
|
F2
|
Edit the
selected cell
|
F3
|
After
a name has
been created F3 will paste names.
|
F4
|
Repeat
last action. For example, if you changed the color of text in another cell
pressing F4 will change the text in cell to the same color.
|
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.
|
Alt +
Enter
|
While
typing text in a cell pressing Alt + Enter will move to the next line
allowing for multiple lines of text in one cell.
|
Shift +
F3
|
Open the
Excel formula window.
|
Shift +
F5
|
Bring up
search box.
|
Ctrl + 1
|
Open the
Format Cells window.
|
Ctrl + A
|
Select
all contents of the worksheet.
|
Ctrl + B
|
Bold
highlighted selection.
|
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 workbooks or windows.
|
