Actually, Ms. Excel plays an important role in our daily work. Today I am gonna show you 35 Ms. Excel shortcuts which can help you to become an advance user as well as improve your daily work faster.
- F2 : Edit Selected Cell
- F11 : New Chart
- F12 : Save As
- 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
- CTRL + ` : Display Formulas
- CTRL + Shift + # : Change Date Format with Day, Month and Year
- CTRL + K : To Insert Hyperlink
- CTRL + Shift + & : Applies Border to Cells
- CTRL + B : Bold
- CTRL + I : Italics
- CTRL + U : Underline
- CTRL+ Shift + $ : Applies the Currency Format to the Selected Cells
- CTRL + Shift + ~ : General 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 + [ : Select all Cells Directly Referenced by Formulas in the Selection
- CTRL + ; : Insert Actual Date
- CTRL + Shift + : : Insert Actual Time
- CTRL + A : Select All
- 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 + Spacebar : Select the Entire Column
- Shift + Spacebar : Select the Entire Row
Kindly comment below if you have other Ms. Excel shortcuts.