Solved

Create Labels in Microsoft Word with specific formatting

Posted on 2014-12-06
2
112 Views
Last Modified: 2014-12-08
I need to create labels in Microsoft Word with the fields in specific locations on the label regardless of the number of characters in the field based on the data.  On one of the lines on my labels, there will be three words which will act as headers for the next three rows of data below.  I want the values from the three rows of data to line up underneath the appropriate header.  The data comes from an Excel spreadsheet.

I put 10 spaces between the data fields to provide some spacing, but the data expands based on the number of characters in the field.

Here is an example of what happens with the normal formatting.  
Animal                        Color               Sex
cat          multi-colored          male
elephant          grey          female
hippopotamus          grey          male

I want it to look more like this.

Animal                        Color               Sex
cat                     multi-colored          male
elephant                    grey             female
hippopotamus          grey               male
0
Comment
Question by:sxlowry
  • 2
2 Comments
 
LVL 90

Accepted Solution

by:
John Hurst earned 500 total points
ID: 40484604
When I pull up a label in Word, there are some significant limits on formatting within the label. I cannot use tabs or other formatting that assists alignment.

So with native Word, I do not think you can do this in labels.

The only workaround I can imagine is to format the text in normal Word and then align it to print on the label stock you want.  But do not use the label wizard under Mailings.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 40487749
@sxlowry - Thanks and I was happy to help.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
Viewers will learn the basics of using filtering and sorting in Excel 2013.
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now