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.
Fantastic list. Welcome to the #excel community
Try F4 to lock in cell references
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yeah. Thanks for your advice.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
helpful... thanks for sharing
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very useful.Thanks for sharing
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You're welcome.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good post. TFS
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very useful article for most of MS Office users + Excel users.
Thanks for sharing this bro!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks bro.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks really helpfull
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @sensambath! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPDownvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks for the info ,its very useful
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
My pleasure.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @sensambath! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Informative post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Useful stuff
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @sensambath! You have received a personal award!
Click on the badge to view your Board of Honor.
Do not miss the last post from @steemitboard!
Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice and useful post...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit