ctrl +1 |
open the format cells dialog box |
ctrl+2 |
Bold |
ctrl+3 |
italic |
ctrl+4 |
underline |
ctrl+5 |
strike through |
ctrl+6 |
show/ hide object |
ctrl+9 |
hide row |
ctrl+shift+9 |
unhide row |
ctrl+o |
Hide column |
ctrl+shift+o |
unhide column |
ctrl+~ |
Increase column width |
ctrl+pgdown |
switch to the next worksheet |
ctrl+ Pgup |
switch to the previous sheet |
Home |
Return to the 1st cell of the current row in a worksheet . |
ctrl+ home |
Move to the last used cell of the current worksheet. |
ctrl+space |
select entire column |
shift+ space |
select entire row |
ctrl+ - |
Delete (Row, columns or cell)
|
ctrl + ; |
insert current date |
ctrl + shift+ : |
insert current time |
ctrl + F1 |
shown/hide the Excel Ribbon |
ctrl+F4 |
close window |
ctrl + F9 |
Minimize workbook |
ctrl +F10 |
Maximize window |
ctrl + F12 |
Open File |
F2 |
Edit the current cell |
Alt + Enter |
In cell editing mode, enter a new line. |
ctrl +sh +home |
select entire range of cell from end to start |
ctrl +sh+ End |
select entire range of cell from start to end |
ctrl +sh+'' |
copy value from cell above |
ctrl + sh+ & |
Place outline border around selected cell |
ctrl +sh+ _ |
Remove outline border |
ctrl + sh+ + |
Insert (row, columns or cell) |
ctrl + sh +~ |
General number format |
ctrl + sh +! |
Two decimal places, thousands separator ex-16618 change 16,618.00 |
ctrl +sh +$ |
Currency format with two decimal places |
ctrl +sh+% |
Percentage format with no decimal places (apply blank cell) |
ctrl + sh +^ |
Scientific rotation number format with two decimals |
Alt +ctrl +v |
paste special box |
ctrl +Alt+v+t |
paste format only |
Alt +w+f |
(un)Freeze window |
F8 |
Anchor to highlight |
F11 |
New chart |
F12 |
Save as |
shift +F2 |
Insert a comment |
shift +F3 |
Insert function box |
shift+ F5 |
Find |
shift +F8 |
Add to selection |
shift +F10 |
Display shortcut menu |
shift + F11 |
New worksheet |