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 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 ✅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 🔔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 Step #2 Enter print content ✅Back to the Home page. ✅Select View, then select Page Layout.See image below ✅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 Step #3 Print preview and printing ✅Press Ctrl+P to check size and print preview.✅Click Print or press Enter. See image below 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