How can i print labels from excel

How to Print labels from Excel without Word. Microsoft Office Newbies. Verify your account to enable IT peers to see that you are a professional. Jun 12, 1 Minute Read. Reply 0.

Facebook Twitter Reddit LinkedIn. Eric Schmidt This person is a verified professional. Main Areas of Contribution:. Track Progress. Earn Credits. For this example we will be using our Dymo Compatible large shipping label. The Dymo software makes it easy for you to input your own company name like we have done here in the heading of our label. Release your mouse to place the address box on your label. Now, resize your address box to the desired size for your Dymo label.

Now, using your mouse, click the address box and select it. Click next, which will bring you to the following step in importing your data. Here you need to select the address box you just created as the destination for your data fields. Now simply drag and drop your columns to your desired output by using your mouse and clicking on the field name Field1, Field2, Field3, etc. You can have more than one field on a line as shown in the preview. The DYMO software gives you a real-time preview to the right so you can see what your labels will look like when printed.

Note: To delete a field, click on the line with the field you want to remove and use your Backspace Key. Once you have your label set up how you like it, press next. Also, have a look at the button New Label … using it, you can create labels of your own with custom dimensions. Now, let us connect the worksheet, which actually is containing the labels data, to these labels and then print it up.

This is the step where your well-formatted column headings will make sense. If you feel you have some labels not assigned proper columns, you can change the same. We are almost done and up-to-the final step of printing named labels for our mailing list. After this step, you will see the mailing labels on a new word sheet and print them.

You can give the print of these labels and use them in your mailing. Here we discuss the Steps to Print Labels from Excel along with examples and a downloadable excel template.

You may also look at the following articles to learn more —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy.