EXCEL SHORTCUT KEYS
EXCEL
SHORTCUT KEYS
Shortcut
Keys
|
Description
|
F7
|
Spell check
selected text and or document.
|
F11
|
Create
chart.
|
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 selection.
|
Ctrl + I
|
Italic
highlighted selection.
|
Ctrl + K
|
Insert
link.
|
Ctrl + U
|
Underline
highlighted selection.
|
Ctrl + 5
|
Strikethrough
highlighted selection.
|
Ctrl + P
|
Bring up
the print dialog box to begin printing.
|
Ctrl + Z
|
Undo last
action.
|
Ctrl +
F9
|
Minimize
current window.
|
Ctrl +
F10
|
Maximize
currently selected window.
|
Ctrl +
F6
|
Switch
between open workbooks / windows.
|
Ctrl +
Page up
|
Move
between Excel work sheets in the same Excel document.
|
Ctrl +
Page down
|
Move
between Excel work sheets in the same Excel document.
|
Ctrl +
Tab
|
Move
between Two or more open Excel files.
|
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
next section of text.
|
Ctrl +
Space
|
|
Shift +
Space
|
Shortcut Keys
|
Description
|
Ctrl + A
|
Select all
contents of the page.
|
Ctrl + B
|
Bold
highlighted selection.
|
Ctrl + C
|
Copy
selected text.
|
Ctrl + X
|
Cut
selected text.
|
Ctrl + P
|
Open the
print window.
|
Ctrl + F
|
Open find
box.
|
Ctrl + I
|
Italic
highlighted selection.
|
Ctrl + K
|
Insert
link.
|
Ctrl + U
|
Underline
highlighted selection.
|
Ctrl + V
|
Paste.
|
Ctrl + Y
|
Repeat the
last action performed.
|
Ctrl + Z
|
Undo last
action.
|
Ctrl + L
|
Aligns the
line or selected text to the left of the screen.
|
Ctrl + E
|
Aligns the
line or selected text to the center of the screen.
|
Ctrl + R
|
Aligns the
line or selected text to the right of the screen.
|
Ctrl + M
|
Indent the
paragraph.
|
Ctrl +
Shift + F
|
Change the
font.
|
Ctrl +
Shift + >
|
Increase
selected font +1.
|
Ctrl + ]
|
Increase
selected font +1.
|
Ctrl +
Shift + <
|
Decrease
selected font -1.
|
Ctrl + [
|
Decrease
selected font -1.
|
Ctrl +
Shift + *
|
View or
hide non printing characters.
|
Ctrl +
<left arrow>
|
Moves one
word to the left.
|
Ctrl +
<right arrow>
|
Moves one
word to the right.
|
Ctrl +
<up arrow>
|
Moves to
the beginning of the line or paragraph.
|
Ctrl +
<down arrow>
|
Moves to
the end of the paragraph.
|
Ctrl +
Del
|
Deletes
word to right of cursor.
|
Ctrl +
Backspace
|
Deletes
word to left of cursor.
|
Ctrl +
End
|
Moves the
cursor to the end of the document.
|
Ctrl +
Home
|
Moves the
cursor to the beginning of the document.
|
Ctrl +
Spacebar
|
Reset
highlighted text to the default font.
|
Ctrl + 1
|
Single-space
lines.
|
Ctrl + 2
|
Double-space
lines.
|
Ctrl + 5
|
1.5-line
spacing.
|
Ctrl +
Alt + 1
|
Changes
text to heading 1.
|
Ctrl +
Alt + 2
|
Changes
text to heading 2.
|
Ctrl +
Alt + 3
|
Changes
text to heading 3.
|
F1
|
Open Help.
|
Shift +
F3
|
Change the
case of the selected text.
|
Shift +
Insert
|
Paste.
|
F4
|
Repeat the
last action performed (2000+)
|
F5
|
Open goto
window.
|
F7
|
Spell check
selected text and or document.
|
Shift +
F7
|
Activate
the thesaurus.
|
F12
|
Save as.
|
Shift +
F12
|
Save
|
No comments:
Post a Comment