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
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.