Excel Shortcut Keys
|
Description
|
F7
|
Spell check
|
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
|
Ctrl + I
|
Italic
|
Ctrl + K
|
Insert hyperlink
|
Ctrl + U
|
Underline
|
Ctrl + 5
|
Strikethrough
|
Ctrl + P
|
Bring up the print dialog box to begin printing
|
Ctrl + Z
|
Undo
|
Ctrl + F9
|
Minimize window
|
Ctrl + F10
|
Maximize window
|
Ctrl + F6
|
Switch between open workbooks
|
Ctrl + Tab
|
Move to next worksheet
|
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
|
Select entire column
|
Shift + Space
|
Select entire row
|
Word Shortcut Keys
|
Function
|
Ctrl + Shift + A
|
All CAPS
|
Ctrl + B
|
Make Bold
|
Esc
|
Cancel
|
Shift + F3
|
Change case
|
Ctrl + W
|
Close document
|
Ctrl + C
|
Copy
|
Ctrl + X
|
Cut
|
Ctrl + Backspace
|
Delete pervious word
|
Ctrl + F
|
Find and Replace
|
Shift + F4
|
Find
|
Ctrl + Shift + [
|
Font, decreased Font by 1 point
|
Ctrl + ]
|
Font, Increased Font by 1 point
|
Ctrl + Shift + <
|
Font, decrease Font down by 1 size
|
Ctrl + Shift + >
|
Font, Increase Font up by 1 size
|
Ctrl + Home
|
Go to the beginning of the document
|
Ctrl + End
|
Go to the end of the document
|
Alt + Shift + D
|
Insert Date field with current Date
|
Alt + Shift + P
|
Insert Page field with current Page
|
Alt + Shift + T
|
Insert Time field with current Time
|
Ctrl + K
|
Insert a hyperlink
|
Ctrl + I
|
Italicize
|
Shift + Enter
|
Line break / new line same paragraph
|
Ctrl + O
|
Open
|
Shift + F7
|
Thesaurus
|
Ctrl + V
|
Paste
|
Ctrl + Enter
|
Page break
|
Ctrl + P
|
Print
|
F7
|
Proofing / Spell Check
|
F4 or Ctrl + Y
|
Repeat / Redo your last action
|
Ctrl + Spacebar
|
Reset Character
|
Ctrl + S
|
Save
|
Ctrl + A
|
Select all
|
Ctrl + Shift + Home
|
Select to the beginning of the document
|
Ctrl + Shift + End
|
Select to the end of the document
|
Ctrl + U
|
Underline
|
Ctrl + Z
|
Undo
|
நன்றி.........அறிமுகம்
|
|
No comments:
Post a Comment