MS Excel Professional Keyboard Shortcut Keys | The Education Pedia
Here is the List of all MS Excel Professional Keyboard Shortcut Keys
MS Excel Keyboard
Shortcuts
|
||
Keys
|
It’s Function
|
|
F2
|
Edit the selected cell
|
|
F5
|
Go to a specific cell
|
|
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 the search box
|
|
Ctrl + A
|
Select all contents of a worksheet
|
|
Ctrl + B
|
Bold highlighted selection
|
|
Ctrl + I
|
Italicize highlighted selection
|
|
Ctrl + C
|
Copy selected text
|
|
Ctrl + V
|
Paste
|
|
Ctrl + D
|
· Fill
|
|
Ctrl + K
|
· Insert link
|
|
Ctrl + F
|
· Open find and replace options
|
|
Ctrl + G
|
· Open go-to options
|
|
Ctrl + H
|
· Open find and replace option
|
|
Ctrl + U
|
· Underline highlighted selection
|
|
Ctrl + Y
|
· Underline selected text
|
|
Ctrl + 5
|
· Strikethrough highlighted selection
|
|
Ctrl + O
|
· Open options
|
|
Ctrl + N
|
· Open new document
|
|
Ctrl + P
|
· Open print dialog box
|
|
Ctrl + S
|
· Save
|
|
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 & Page Down
|
· Move between Excel worksheets in the same document
|
|
Ctrl + Tab
|
· Move between two or more open Excel files
|
|
Alt + =
|
· Create the formula to sum all of the above cells
|
|
Ctrl +
|
· Insert the value of above cell into the current cell
|
|
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 + (Right arrow)
|
· Move to next section of text
|
|
Ctrl + Space
|
· Select entire column
|
|
Shift + Space
|
· Select entire row
|
|
Ctrl + W
|
· Close document
|
|
0 Response to "MS Excel Professional Keyboard Shortcut Keys | The Education Pedia"
Post a Comment