How to print labels from excel

Discussion in 'Excel' started by Gina, Dec 14, 2015.

  1. Gina

    Gina

    Joined:
    Dec 14, 2015
    Messages:
    1
    Likes Received:
    0
    I am having problems printing labels from an excel spreadsheet. I follow all of the steps but when I hit update it only prints the first row (of 3) addresses and the last 2 labels on the page. Why is it doing this? I have tried copying the info into a new document with no spaces... i don't know what I am doing wrong.
     
    Gina, Dec 14, 2015
    #1
    1. Advertisements

  2. Gina

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Unfortunately, you must pair Excel with Word to make it so you can use a wizard to guide you through the process. Assuming Addresses.xlsx is your spreadsheet containing addresses and Labels.docx is a blank new Word document:
    In Labels.docx, select the Mailings ribbon and click the Start Mail Merge dropdown, then select the Step by step mail merge wizard. In the panel that opens up on the right pick Labels, then click Next.
    Label options...
    Select the vendor that matches the one on your box of labels, then select the Product number (also found on the box). [OK]
    Back to the panel - - - Next
    * Use existing list
    Browse... to Addresses.xlsx and open it. Uncheck the box if your address spreadsheet doesn't have column headers. [OK] , then select the addresses you want for your labels. [OK] , then Next.
    Click Address block... Play with the options until the preview looks the way you want it.
    [OK] If you want all your labels in the same format, click [Update all labels]. It's time to preview your labels so hit Next. If you want to preview more than just the first page of labels, on the Panel: [>>]

    I don't usually care for all the space between each line on the labels, so I click the little box in the upper left corner of the page to select all the labels, go to the Home ribbon, Paragraph section, change the Line spacing to 1.0 AND remove the space before (and after) paragraphs. Next, then Print if everything looks good.
     
    XLPadawan, Jun 10, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Ian
    Replies:
    0
    Views:
    839
  2. chel
    Replies:
    0
    Views:
    503
  3. spafax
    Replies:
    0
    Views:
    725
    spafax
    Jan 12, 2012
  4. Emanuele
    Replies:
    0
    Views:
    619
    Emanuele
    Mar 13, 2012
  5. mary86004

    Excel doesn't filter entire list.

    mary86004, Mar 17, 2012, in forum: Excel
    Replies:
    1
    Views:
    766
    CarolB
    Apr 24, 2012
  6. dartanee

    All Shaded Cells print pure black

    dartanee, Jun 29, 2012, in forum: Excel
    Replies:
    1
    Views:
    1,111
    wdroom
    Jul 21, 2012
  7. vahid
    Replies:
    0
    Views:
    264
    vahid
    Apr 21, 2015
  8. Pete Marsh
    Replies:
    0
    Views:
    254
    Pete Marsh
    Nov 26, 2015
Loading...