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.

10000+ Copies Already Downloaded

Category Archives for Formatting

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 Create Barcode Generator Template In Excel

how to create a barcode template in excel featured image

Do you want to create a barcode in excel? So today, just for you, I will reveal the method to create barcode generator template in excel. In this post, I will show you how to generate code 39 barcodes. Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan […]

Check it out now

How To Add Leading Zeros In Excel

how to add leading zeros in excel featured image

You can’t add a zero before a number in excel. Whenever you try to add a leading zero, it disappears. Not matter what, how many zeros you trying to add, it will disappear. Let me tell you what’s the reason for this. In below example, I am trying to start a number with 0 but I […]

Check it out now

Heat Map Template

free download excel heat ma template maker

An excel heat map template can help you present your data in with a strong message about the conclusion. It will also help you to add some extra power in your data.

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