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

Generate Barcode In Excel

how to create a barcode template in excel featured image

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 […]

Check it out now

Add Leading Zeros

how to add leading zeros in excel featured image

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 […]

Check it out now

Excel’s AUTO FORMAT Option

how to use excel auto format option for quick formatting

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 […]

Check it out now

How To Use Format Painter In Excel For Quick Formatting

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.

Check it out now

5 Custom Date Formats You Have To Learn Today Right Now

excel custom date formats

Few, days back, I had explained about how to convert non-standard date formats to standard date formats in my post. But, Sometimes it is required that we use some off track date formats rather than using simple date formats. As we know, excel blessed us with highly flexible options & Custom Date Formats is one […]

Check it out now