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](http://munbyn.com/cdn/shop/articles/4_6ce7ec0b-2239-4833-941d-171ca7a68a73.jpg?v=1657680448&width=1100)
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 |
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](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2.25_x1.25_Thermal_Sticker_Labels1_1024x1024.png?v=1657520408)
🟢Set your margins. (It is recommended that all margins be set at 0.1cm. Of course, you can modify it according to your needs.)
See image below
![set the proper margin to Print 2.25"x1.25" Address Labels in Excel](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2.25_x1.25_Thermal_Sticker_Labels2_1024x1024.png?v=1657520813)
🔔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](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2_x2_Thermal_Sticker_Labels11_1024x1024.png?v=1657523336)
![How to Print Address Labels from Excel - 2.25''x1.25'' Thermal Sticker Labels-4](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2_x2_Thermal_Sticker_Labels12_1024x1024.png?v=1657523368)
![change units to Print Address Labels in Excel with 2.25''x1.25'' Thermal Labels](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2_x2_Thermal_Sticker_Labels13_1024x1024.png?v=1657523428)
Step #2 Enter print content
✅Back to the Home page.
✅Select View, then select Page Layout.
See image below
✅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](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2.25_x1.25_Thermal_Sticker_Labels4_1024x1024.png?v=1657521028)
![enter content to print Address Labels from Excel with 2.25''x1.25'' Thermal Sticker Labels](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2.25_x1.25_Thermal_Sticker_Labels5_1024x1024.png?v=1657521058)
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](https://cdn.shopify.com/s/files/1/2652/5526/files/How_to_Print_Shipping_Address_Labels_from_Excel_-_2.25_x1.25_Thermal_Sticker_Labels6_1024x1024.png?v=1657521094)
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
1 comment
To the munbyn.com admin, Your posts are always a great read.