2015 Useful shortcuts every Microsoft excel user should know

   These are the short cuts You can use on Microsoft excel 1. To format any selected object- press ctrl+12. To insert current date- press ctrl+;3. To insert current time- press ctrl+shift+;4. To repeat last action- press F45. To edit a cell comment- press shift + F26. To autosum selected cells- press alt + =7. To see the suggest drop-down in a cell- press alt + down arrow8. To enter multiple lines in a cell- press alt+enter9. To insert a new sheet- press shift + F1110. To edit active cell- press F2 (places cursor in the end)11. To hide current row- press ctrl+912. To hide current column- press ctrl+013. To unhide rows in selected range- press ctrl+shift+914. To unhide columns in selected range- press ctrl+shift+015. To recalculate formulas- press F916. To select data in current region- press ctrl+shift+817. 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 F419. To format a number as currency- press ctrl+shift+4 (ctrl+$)20. To apply outline border around selected cells- press ctrl+shift+721. To open the macros dialog box- press alt+F822. To copy value from above cell- press ctrl+’23. To format current cell with comma formats- press ctrl+shift+124. To go to the next worksheet- press ctrl+shift+pg down