Solved

Create Labels in Microsoft Word with specific formatting

Posted on 2014-12-06
2
114 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 92

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 92

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA Hide Row Based on Cell Color 19 172
Macro which simplifies accounts 6 53
Excel Array formula Help 11 53
Calculating Percentile Value inside Excel. 2 61
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…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.

911 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

18 Experts available now in Live!

Get 1:1 Help Now