Excel or Word help!

[Inn3rs3lf]

Hey all,

I need to make labels for boxes, but getting the layout correct is causing me headaches!

The labels I have are 3 columns of 8. So three width, and 8 length of an A4 sheet. I need a layout whereby all I need to do is paste the image on each "label" within word or excel.

I have found the following: http://www.sheetlabels.co.uk/products/matt-white-printer-labels-63-x-34mm/25128

Only problem is, when I paste the image, it goes behind the template, so I am not sure if it is centered or not, which has caused even more headaches!

I need to do 67 different labels, so it is becoming time consuming to say the least. One large Excel sheet would be preferred over word if one is capable of helping me out.

Thanks so much guys.

 

[krono9]

When I do labels in word... i use a combination of "grouping" items together...and also the send backward/ send forward/ behind text/ infront of text commands...

 

[Urist]

right click on the table of labels
Order -> Set behind text

click on your image
format(top menu)->wrap text->In front of text

Now you can drag it wherever you want

 

[AfricanTech]

Hmm, this might sound unhelpful, but it's not

Spend the time learning how to use the "labelling" functions in Word properly and you will benefit for years to come

ie. don't set it up manually, use the the built-in functionality (in Word 2013, it's under the "Mailings" menu item - once you figure it out you'll thank me for the time saving in the medium to long term.

 

[Inn3rs3lf]

Guys, thank you so much!!!!