circle(cx="16",cy="50",r="10")

How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels

Trying to print shipping address labels from Excel can be frustrating because it's easy to make mistakes and end up with a label that you can't use. If you've been through this, you're not alone; many consider it a daunting task. This post will show you how to print shipping address labels quickly and easily from Excel.

DIFFICULTY

🔳Easy

DURATION

🔳12 minutes

WHAT YOU NEED

🔳Microsoft Excel

🔳Thermal Label Printer-ITPP941

🔳4''x6'' Thermal Shipping Labels

    Recommended article: 

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

    Step #1 Select the corresponding paper size(4''x6'')

    ✅Create a new Excel document.
    ✅Press Ctrl+P.
    ✅Select Custom Page Size - 4''x6'' (102mm x 152mm).

    See image below

    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-1

    ✅Click Page Setup.

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

    ✅Select OK to save the settings.

    See image below

    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping 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

    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-3
    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-4

    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-5

    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 - 4''x6'' Thermal Shipping 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 - 4''x6'' Thermal Shipping Labels-7
    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping 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

    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-9
    How to Print Shipping Address Labels from Excel - 4''x6'' Thermal Shipping Labels-10

    Recommended article: 

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

    Leave a comment

    Please note, comments must be approved before they are published

    Your cart is currently empty