Solved

Create Labels in Microsoft Word with specific formatting

Posted on 2014-12-06
2
125 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 96

Accepted Solution

by:
Experienced Member 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 96

Expert Comment

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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: 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…
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.
Viewers will learn how to find and create templates in Excel 2013.

617 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