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

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

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