Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Create Labels in Microsoft Word with specific formatting

Posted on 2014-12-06
2
Medium Priority
?
136 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:Steve Lowry
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 97

Accepted Solution

by:
John Hurst earned 2000 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 97

Expert Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

722 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