| EXCEL/Keyboard SHORTCUT KEYS |
| Ctrl C |
copy |
|
alt ED |
delete all cell/column |
| Ctrl V |
paste |
|
Alt F4 |
close all open docs |
| Ctrl X |
cut |
|
ALT any number |
insert symbol (smiley) ☺☻♥ |
| Ctrl Y |
redo |
|
ALT + = |
AutoSum |
| Ctrl Z |
undo |
|
Alt 164/165 |
ñ/Ñ |
| Ctrl B |
bold |
|
Alt D FF |
Filter/remove filter |
| Ctrl I |
Italic |
|
Alt arrow down |
to show filtered item |
| Ctrl S |
Italic |
|
Alt A Q / Alt D F A |
Advance Filter |
| Ctrl U |
underline |
|
Alt D P (next) enter |
to insert Pivot Table |
| Ctrl F |
Find |
|
Alt D S |
sort |
| Ctrl H |
replace |
|
ALT EL |
Delete the current sheet |
| CTRL K |
Insert a hyperlink. |
|
ALT EM |
Move or copy the current sheet |
| CTRL P |
Print |
|
ALT OHR |
Rename the current sheet |
| CTRL O |
Open file box |
|
Alt T PP |
to lock or unlock sheet |
| Ctrl W |
close current window (docs) |
|
Alt W FF |
Freeze panes/unfreeze |
| Ctrl N |
open new blank excel sheet |
|
|
to insert Border line |
| Ctrl Alt Arrow |
rotate active window |
|
Alt H F S |
change font size |
| Ctrl D |
copy upper cell |
|
Alt F11 |
to insert Visual basic |
| Ctrl End |
go to end of the sheet |
|
Alt F |
File tab |
| CTRL F10 |
Maximize or restore the selected workbook window. |
|
Alt H |
Home tab |
| CTRL F9 |
Minimize a workbook window to an icon. |
|
Alt N |
Insert tab |
| Ctrl Home |
go to upper part of the sheet |
|
Alt P |
Page Lay out tab |
| Ctrl arrow down |
move until to tha last down cell |
|
Alt M |
Formulas tab |
| Ctrl arrow right |
move until to tha last right cell |
|
Alt A |
Data tab |
| CTRL SHIFT N |
create new folder |
|
Alt D EE |
Text to Column |
| CTRL ; |
Enter the date. |
|
Alt W M |
Macro |
| CTRL SHIFT ; |
Enter the time. |
|
Alt A M |
Remove Duplicates |
| Ctrl A |
highlight all Sheet |
|
Altl tab |
switch window to another |
| Ctrl Alt delete |
log off computer |
|
Alt R W |
to share workbook (multiple user at a time) |
| Ctrl space bar |
highlight column |
|
Alt W Q |
Zoom |
| Shift Space bar |
highlight row |
|
right command |
right click (mouse) format cells |
| Ctrl spacebar right com(mouse) D |
delete all column |
|
Shift delete |
delete permanently (also to recycle bin) |
|
|
to move bet. sheet |
|
SHIFT F11 |
Insert a new worksheet. |
| =upper(txt) |
UPPER CASE |
|
SHIFT F3 |
display the Insert Function dialog box. |
| =Proper(txt) |
Proper Case |
|
(highlight) alt IC |
insert column |
| =lower(txt) |
lower case |
|
(highlight) alt IR |
insert cells |
| F12 |
Save AS |
|
|
|
| F2 |
edit CELL/rename |
|
|
|
| F7 |
Display the Spelling dialog box. |
|
|
|
| window down arrow |
minimize window |
|
|
|
| window L |
lock the computer |
|
|
|
| window D |
show desktop (minimize all open docs) |
|
|
|
| window E |
go to MY COMPUTER |
|
|
|