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

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

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

select the paper size to Print Address Labels from Excel with 4''x6'' Thermal Shipping Labels

✅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

set the label margin to Print Address Labels from Excel with 4''x6'' Thermal Shipping Labels

🔔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 - 4''x6'' Thermal Shipping Labels-3

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

change the units to Print Address Labels from Excel with 4''x6'' Thermal Shipping Labels

Step #2 Enter print content

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

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

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

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

examples of 4''x6'' Thermal address labels

North America

Europe

Oceania

North America

Europe

Oceania