The Best Excel Shortcuts You Need to Know

Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky spreadsheets. In order to help you work a little bit faster, or maybe more efficiently. Find below best Excel shortcuts that you need to know!

• F2 : Edit selected cell
• F9 : Calculates all worksheets
• F11 : New chart
• ALT : Access the ribbon for formulas
• ALT + = : Automatically SUM() selected
• ALT + Enter : Start a new line in the same cell
• ALT + o-c-a : Auto size columns
• PG + UP/PG+DOWN : Go to next/previous worksheet
• CTRL + ` : Display Formulas
• CTRL + Backspace : Show active cell
• CTRL + Shift + # : Change Date format with day, month and year.
• CTRL + K : To insert Hyperlink.
• CTRL+ Shift + $ : Applies the currency format to the selected cells.
• CTRL + Shift + & : Applies border to cells
• CTRL + B : Bold
• CTRL + I : Italics
• CTRL + U : Underline
• CTRL + Shift + ~ : General style number
• CTRL + Shift + $ : Currency style number
• CTRL + Shift + % : Percentage style Number
• CTRL + Shift + ^  : Scientific notation style
• CTRL + Shift + # :  Date style
• CTRL + Shift + @ : Time Style
• CTRL + Shift +! : Number Style
• CTRL + F12 : Open
• CTRL + Spacebar : Select the entire column
• CTRL + [ : Select all cells directly referenced by formulas in the selection
• CTRL + A : Select All
• CTRL + Shift + J : List Constants
• CTRL + D : Copy equation down
• CTRL + F : Find
• CTRL + H : Find&Replace
• CTRL + Right arrow : Move right
• CTRL + Left arrow : Move left
• CTRL + Up arrow : Move up
• CTRL + Down arrow : Move down
• CTRL + Enter : Same data in multiple cells
• Shift + Spacebar : Select the entire row
• Shift + F3 : Find Previous