1.
To
format any selected object, press ctrl+1
2.
To
insert current date, press ctrl+;
3.
To
insert current time, press ctrl+shift+;
4.
To
repeat last action, press F4
5.
To edit
a cell comment, press shift + F2
6.
To
autosum selected cells, press alt + =
7.
To see
the suggest drop-down in a cell, press alt + down arrow
8.
To
enter multiple lines in a cell, press alt+enter
9.
To
insert a new sheet, press shift + F11
10.
To edit
active cell, press F2 (places cursor in the end)
11.
To hide
current row, press ctrl+9
12.
To hide
current column, press ctrl+0
13.
To
unhide rows in selected range, press ctrl+shift+9
14. To insert a instant chart, press alt+F1
15.
To
recalculate formulas, press F9
16.
To
select data in current region, press ctrl+shift+8
17.
To see
formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18.
While
editing formulas to change the reference type from absolute to relative vice
versa, press F4
19.
To
format a number as currency, press ctrl+shift+4 (ctrl+$)
20.
To
apply outline border around selected cells, press ctrl+shift+7
21.
To open
the macros dialog box, press alt+F8
22.
To copy
value from above cell, press ctrl+’
23.
To
format current cell with comma formats, press ctrl+shift+1
24.
To go
to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press
ctrl+shift+pg up
Reference:
follow us on
http://arivilm.blogspot.in
like us on
https://www.facebook.com/Arivilm2501/
No comments:
Post a Comment