Excel Shortcut to format general numbers

Remember the project that dropped in the last moment and a whole lot of data that needed formatting? How harrowing an experience would have been if each and every cell needed formatting? And an even more distressing task when the formatting had to be done on general numbers? Only few excel users can actually remember the harrowing experience when they had to go through such incidents. Let’s suppose you have an important decimal or percentage to be put into every value that unfortunately escaped your memory. Are you going to switch back and forth to the Home page to adjust the formatting? No matter how good you are at locating the formatting tabs, you will always end up utilizing ample amount of time that you would have actually used into some constructive thing.

To save you from the last-minute horror and help you develop a professional looking model, we have a shortcut! Yes, precisely, a shortcut that can make your job easier and faster!

excel 1

The shortcut to format general numbers in Windows is:

Ctrl + Shift + 5 - Percentage Formatting (%)


Having learnt the Shortcut for Formatting General Numbers, learn Excel Shortcuts for Comments and Excel Shortcut for Hyperlinks

Excel Shortcuts for Comments
Excel Shortcut for Hyperlinks

I am greatly impressed by the quality of your training. In fact it is the reason I am going to take the exam this time as I had previously decided not to take it because the quality of the training I had purchased was not what I had expected. All the best to you and everyone at Edupristine.
I am very pleased to have found these courses offered by a recognized, reputable training firm at a great value! Thank you!

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by Edu for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP is not responsible for any fees or costs paid by the user to Edu nor is GARP responsible for any fees or costs of any person or entity providing any services to Edu Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas®, and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to legal@edupristine.com and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

2015 © Edupristine. ALL Rights Reserved.

tick_classroom_city.php Post ID = 56557