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 Reading

Add 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 Reading

Excel’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 Reading

How 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 Reading

5 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