Very Useful Keyboard Shortcuts
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 autosum selected cells, press alt + =
5. To see the suggest drop-down in a cell, press alt + down arrow
6. To enter multiple lines in a cell, press alt+enter
7. To insert a new sheet, press shift + F11
8. To edit active cell, press F2 (places cursor in the end)
9. To hide current row, press ctrl+9
10. To hide current column, press ctrl+0
11. To unhide rows in selected range, press ctrl+shift+9
12. To unhide columns in selected range, press ctrl+shift+0
13. To recalculate formulas, press F9
14. To apply outline border around selected cells, press ctrl+shift+7
15. To open the macros dialog box, press alt+F8
16. To copy value from above cell, press ctrl+’
17. To format current cell with comma formats, press ctrl+shift+1
18. To go to the next worksheet, press ctrl+shift+pg down
19. To go to the previous worksheet, press ctrl+shift+pg up
3. To insert current time, press ctrl+shift+;
4. To autosum selected cells, press alt + =
5. To see the suggest drop-down in a cell, press alt + down arrow
6. To enter multiple lines in a cell, press alt+enter
7. To insert a new sheet, press shift + F11
8. To edit active cell, press F2 (places cursor in the end)
9. To hide current row, press ctrl+9
10. To hide current column, press ctrl+0
11. To unhide rows in selected range, press ctrl+shift+9
12. To unhide columns in selected range, press ctrl+shift+0
13. To recalculate formulas, press F9
14. To apply outline border around selected cells, press ctrl+shift+7
15. To open the macros dialog box, press alt+F8
16. To copy value from above cell, press ctrl+’
17. To format current cell with comma formats, press ctrl+shift+1
18. To go to the next worksheet, press ctrl+shift+pg down
19. To go to the previous worksheet, press ctrl+shift+pg up
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757