|
Shortcut
|
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 +
I
|
Italic
highlighted selection.
|
|
Ctrl +
K
|
Insert link.
|
|
Ctrl +
S
|
Save
the open worksheet.
|
|
Ctrl +
U
|
Underline
highlighted selection.
|
|
Ctrl +
1
|
Change
the format of selected cells.
|
|
Ctrl +
5
|
Strikethrough highlighted selection.
|
|
Ctrl +
P
|
Bring
up the print dialog box to begin the printing process.
|
|
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.
|
|
Ctrl +
Page up
|
Move
between work sheets in the same document.
|
|
Ctrl +
Page down
|
Move
between work sheets in the same document.
|
|
Ctrl +
Tab
|
Move
between Two or more open Excel files.
|
|
Alt + =
|
Create
a formula to sum all of the above cells.
|
|
Ctrl +
'
|
Insert
the value of the above cell into the cell currently selected.
|
|
Ctrl +
Shift + 1
|
Format
number in comma format.
|
|
Ctrl +
Shift + 4
|
Format
number in currency format.
|
|
Ctrl +
Shift + 3
|
Format
number in date format.
|
|
Ctrl +
Shift + 5
|
Format
number in percentage format.
|
|
Ctrl +
Shift + 6
|
Format
number in scientific format.
|
|
Ctrl +
Shift + 2
|
Format
number in time format.
|
|
Ctrl +
Arrow key
|
Move to
next section of 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.
|
Monday, 29 September 2014
Microsoft Excel shortcut keys
0 comments:
Post a Comment