Useful Tips For Excel Keyboard Shortcuts

3561 Views

Useful Tips For Excel 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 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 unhide columns in selected range, press ctrl shift 0
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

0 Comments

Leave a Reply