|
Ctrl+A |
Apply to select
all cells |
|
Ctrl+B |
Apply/Remove
bold formatting |
|
Ctrl+C |
Apply to copy
the selected word |
|
Ctrl+D |
Apply to fill
down the selected cell |
Shortcut keys Action
Ctrl+F
Display the Find what option
Ctrl+G
Apply to run Go to dialog box
Ctrl+H
Use to display Find and Replace dialog box
Ctrl+I
Apply/Remove Italic formatting
Ctrl+K
Apply to insert Hyperlink dialog box
Ctrl+L
Press keys to insert Create list dialog box
Ctrl+N
Press Keys to create new file
Ctrl+O
Press Keys to open new file
Ctrl+P
Press Keys to display Print dialog box
Ctrl+S
Save the active file
Ctrl+U
Press Keys to apply/remove underline
Ctrl+V
Press Keys to paste the clipboard values
Ctrl+X
Press Keys to cut the selected word
Ctrl+Y
Press Keys to run previous action
Ctrl+Z
Apply to undo the previous command
Uses of Function keys in Excel
Function keys Action
F1 Use to give the help of any windows panel
F2 Press Keys to edit any cell
F3
Use to insert name into formula
F4 Apply to repeat the previous command
F5 Apply to run Go to dialog box
F6 Apply to move between panel in worksheet
F7 Use to check spelling in worksheet
F8 Apply the extend mode on the status line
F9 Use to calculate the worksheets
F10 Use to select the main menu bar
F11 Apply to insert the chart of active
worksheet
F12 Use to run Save As dialog box.