Print Address Labels from Excel with 2''x2'' Thermal Sticker Labels

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

If you want to save a lot of time, knowing how to make shipping address labels from Excel. Following these steps is good practice for making sure you are efficient with your time and don’t cause yourself any grief when it’s time to create shipping address labels.

DIFFICULTY

🔳Easy

DURATION

🔳12 minutes

WHAT YOU NEED

🔳Microsoft Excel

🔳Thermal Label Printer-ITPP941

🔳2''x2'' 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.25''x1.25'' Thermal Sticker Labels

    Step #1 Select the corresponding paper size(2''x2'')

    ✅Create a new Excel document.
    Press Ctrl+P.
    ✅Select Custom Page Size - 2''x2'' (51mm x 51mm).

    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

    How to Print Address Labels from Excel with 2''x2'' Thermal Sticker Labels-2

    🔔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

    Print Address Labels from Excel - 2''x2'' Thermal Sticker Labels-3
    Print Address Labels from Excel - 2''x2'' Thermal Sticker Labels-4
    change the units to Print Address Labels from Excel with 2''x2'' Thermal Sticker 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''x2'' 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). 
    Since round stickers are used as printed labels, it is recommended that the text be centered.

    See image below

    Print Address Labels in Excel with 2''x2'' Thermal Sticker Labels-7
    enter content to Print Address Labels from Excel with 2''x2'' Thermal Sticker Labels-8

    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 in Excel
    examples of 2" Address 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.25''x1.25'' 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.