Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Category Archives for Formatting
Steps to Install Font to Generate Barcode In Excel
People who track stock, sales, and purchases in Excel often ask me “how can we generate a barcode in Excel?”.Well, in Excel there is no default option to generate a barcode.And, the bad news is:There is no plan of Microsoft to add any option like this.But here is the good news:You can generate a barcode […]
➲ Continue ReadingAdd Leading Zeros in Excel
There are few default rules in Excel which can annoy you. And, one of those rules is you can’t add a zero before a number.The reason behind this is, a zero before a number makes no sense and no value to the number itself.Whenever you try to insert a zero before a number, Excel removes […]
➲ Continue ReadingExcel’s AUTO FORMAT Option
Formatting is a tedious task. It’s really hard to format your data every time when you present it to someone.But, this is the only thing which makes your data more meaning full and easy to consume. It would be great if you have an option which you can use to format your data without spending […]
➲ Continue ReadingHow To Use Format Painter In Excel For Quick Formatting
If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.
➲ Continue Reading5 Custom Date Formats I Always Use and You Should Too
A few days back, I have explained about how to convert text into a date. But sometimes we need to use a custom date format which is not as per standard date formats.As you know, we are blessed with custom formatting so you can create a custom date with a regular date serial number.The benefit […]
➲ Continue Reading