Excel Productivity Guide

Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.

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

        How To Create a Excel Heat Map Template [Step By Step]

          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

            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

              4 Quick Tips To Customize a Cell Comment In Excel

                Cell Comment is like a Small Note in Excel which you can put on the cell to deliver an important message related to that particular cell.  By using customized cell comment you can add a plus to your data presentation. Here, I have listed 4 useful tips to customize cell comment in excel which can help you […]

                Check it out now