MS-EXCEL SHORTCUT
SHORTCUT |
MS-EXCEL |
Ctrl+A |
Select all contents of the worksheet. |
Ctrl+B |
Bold highlighted selection. |
Ctrl+C |
Copy the cell |
Ctrl+D |
Fill down. Fills the cell beneath with the contents of
the selected cell. To fill more than one cell, select the source cell and
press Ctrl+Shift+Down to select multiple cells. Then
press Ctrl+D to fill them with the contents of the original
cell. |
Ctrl+E |
|
Ctrl+F |
Find |
Ctrl+G |
Goto |
Ctrl+H |
Replace |
Ctrl+I |
Italic highlighted selection. |
Ctrl+J |
To enter the line break character |
Ctrl+K |
|
Ctrl+L |
Create a table |
Ctrl+M |
to activate a "Move" function |
Ctrl+N |
Create a new work book |
Ctrl+O |
Open a excel |
Ctrl+P |
Print |
Ctrl+Q |
Display the Quick Analysis options for
selected cells that contain data. |
Ctrl+R |
Fill right. Fills the cell to the right with the
contents of the selected cell. To fill more than one cell, select the source
cell and press Ctrl+Shift+Right to select multiple cells.
Then press Ctrl+R to fill them with the contents of the
original cell. |
Ctrl+S |
Save the open worksheet. |
Ctrl+T |
Convert cell to table |
Ctrl+U |
Underline highlighted selection. |
Ctrl+V |
Paste |
Ctrl+W |
Close the current window |
Ctrl+X |
Cut |
Ctrl+Y |
Undo |
Ctrl+Z |
Repeat |
SHORT CUT |
MS-EXCEL |
Ctrl+1 |
Format cells dialog box |
Ctrl+2 |
Bold |
Ctrl+3 |
Italic |
Ctrl+4 |
Underline |
Ctrl+5 |
Strikethrough |
Ctrl+6 |
Show/Hide objects |
Ctrl+7 |
Show/Hide Standard toolbar |
Ctrl+8 |
Toggle Outline symbols |
Ctrl+9 |
Hide rows |
Ctrl+0 |
Hide columns |
FUNCTION kEY |
MS-EXCEL |
F1 |
Help |
F2 |
Edit |
F3 |
Paste Name |
F4 |
Repeat last action |
F5 |
Goto |
F6 |
Next Pane |
F7 |
Spell check |
F8 |
Extend mode |
F9 |
Recalculate all workbooks |
F10 |
Activate Menubar |
F11 |
New Chart |
F12 |
Save As |
SHORTCUT |
MS-EXCEL |
Ctrl+Shift+( |
Unhide rows |
Ctrl+Shift+) |
Unhide columns |
Alt or F10 |
Activate the menu |
Crtl +Tab |
In a workbook: activate next workbook |
Tab |
Next tool |
Shift+Tab |
Previous tool |
Enter |
Do the command |
Alt+Enter |
Start a new line in the same cell. |
Ctrl+Enter |
Fill the selected cell range with the current entry. |
Ctrl+Spacebar |
Select the entire column |
Shift+Spacebar |
Select the entire row |
CTRL+PgUp |
Switches between worksheet tabs, from left-to-right. |
CTRL+PgDn |
Switches between worksheet tabs, from right-to-left. |
Ctrl+" |
Copy Value from Cell Above |
Ctrl+’ |
Copy Formula from Cell Above |
Ctrl+: |
Insert Current Time |
Ctrl+; |
Insert Current Date |
SHORTCUT |
MS-EXCEL |
Alt+= |
AutoSum |
Ctrl+` |
Toggle Value/Formula display |
Ctrl+Shift+A |
Insert argument names into formula |
Alt+Down arrow |
Display AutoComplete list |
Alt+’ |
Format Style dialog box |
Ctrl+Shift+~ |
General format |
Ctrl+Shift+! |
Comma format |
Ctrl+Shift+@ |
Time format |
Ctrl+Shift+# |
Date format |
Ctrl+Shift+$ |
Currency format |
Ctrl+Shift+% |
Percent format |
Ctrl+Shift+^ |
Exponential format |
Ctrl+Shift+& |
Place outline border around selected cells |
Ctrl+Shift+_ |
Remove outline border |
Ctrl+Shift+* |
Select the current region around the active cell. In a PivotTable report,
select the entire PivotTable report. |
Ctrl++ |
Insert |
Ctrl+- |
Delete |
SHORT CUT |
MS-WORD |
MS-EXCEL |
Shift+F1 |
Start context-sensitive Help or reveal formatting. |
What’s This? |
Shift+F2 |
Copy text. |
Edit cell comment |
Shift+F3 |
Change the case of letters. |
Paste function into formula |
Shift+F4 |
Repeat a Find or Go To action. |
Find Next |
Shift+F5 |
Move to the last change. |
Find |
Shift+F6 |
Go to the previous pane or frame (after pressing F6). |
Previous Pane |
Shift+F7 |
Choose the Thesaurus command (Review tab, Proofing
group). |
|
Shift+F8 |
Reduce the size of a selection. |
Add to selection |
Shift+F9 |
Switch between a field code and its result. |
Calculate active worksheet |
Shift+F10 |
Display a shortcut menu. |
Display shortcut menu |
Shift+F11 |
Go to the previous field. |
New worksheet |
Shift+F12 |
Choose the Save command. |
Save |
Comments
Post a Comment