How to Print Shipping Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels

How to Print Shipping Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels

From an efficiency standpoint, it is recommended to print shipping address labels, which you can customize in a number of ways. For example, use a brand logo for each label, or choose a unique font, or add a unique design element. This custom shipping address label can help you stand out from your competitors.

A simple way to create and print shipping address labels is to use Microsoft Excel. Here are some simple steps:

DIFFICULTY

🔳Easy

DURATION

🔳12 minutes

WHAT YOU NEED

🔳Microsoft Excel

🔳Thermal Label Printer-ITPP941

🔳2.25''x1.25'' Thermal Labels

    Recommended article: 

    📄How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Sticker Labels
    📄How to Print Shipping Address Labels from Excel - 2''x2'' Thermal Sticker Labels

    Step #1 Select the corresponding paper size(2.25''x1.25'')

    ✅Create a new Excel document.
    Press Ctrl+P.
    ✅Select Custom Page Size - 2.25''x1.25'' (57mm x 32mm).

    See image below

    select the label size to Print Address Labels from Excel
    ✅Click Page Setup.

    🟢Set your margins. (It is recommended that all margins be set at 0.1cm. Of course, you can modify it according to your needs.)

    ✅Select OK to save the settings.

    See image below

    set the proper margin to Print 2.25"x1.25" Address Labels in Excel

    🔔If the unit of margins is inches, you can change it as follows

    Go to File > Options > Advanced.
    Scroll down to Display.
    ✅Select your desired measurement unit from the list.
    Select OK.

    See image below

    How to Print Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels-3
    How to Print Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels-4
    change units to Print Address Labels in Excel with 2.25''x1.25'' Thermal Labels

    Step #2 Enter print content

    ✅Back to the Home page.
    ✅Select View, then select Page Layout.
    See image below

    How to Print Shipping Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels-6

    The table will be divided according to the size of the label you pre-selected.
    ✅Adujust the column width and row height. Enter the content you want to print (eg: address information).

    See image below

    How to Print Shipping Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels-7
    enter content to print Address Labels from Excel with 2.25''x1.25'' Thermal Sticker Labels

    Step #3 Print preview and printing

    ✅Press Ctrl+P to check size and print preview.
    ✅Click Print or press Enter.

    See image below

    Print Address Labels from Excel with 2.25''x1.25'' Thermal Sticker Labels
    examples of 2.25"x1.25" Address Labels in Excel

    Recommended article: 

    📄How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Sticker Labels
    📄How to Print Shipping Address Labels from Excel - 2''x2'' Thermal Sticker Labels

    Table of Contents

    Leave a comment

    All comments are moderated before being published.

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.