Label Columns
 

I hope I can explain this easily. I am using an excel document with two
columns (A and B). How can I print the labels (which are two columned) so
that Column A from excel is to the left of column B when printed onto labels.
I am trying to make it easy on myself when I go to peel the labels that I
can peel the left label and then place the right label with it. It is
different information and they cannot be on the same label. Is there a way
to do this?

Well to start off with printing labels is never easy from Excel, though you
would thing nothing could be simpler. But Microsoft decided that you should
print labels from MS Word.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If you do not have MS Word you will need a different solution, probably with
a lot more frustration. Or else create a text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mjcox" wrote in message ...
I hope I can explain this easily. I am using an excel document with two
columns (A and B). How can I print the labels (which are two columned) so
that Column A from excel is to the left of column B when printed onto labels.
I am trying to make it easy on myself when I go to peel the labels that I
can peel the left label and then place the right label with it. It is
different information and they cannot be on the same label. Is there a way
to do this?

I understand that I have to do this as a mail merge from Microsoft Word but I
am unsure of how to do what I need to do. Maybe it cannot be done but I
thought that someone might be able to help me. I appreciate your reply. I
looked at the hyperlink that you gave but it was really no help. I just hope
that I am clear in what I am asking for.

"David McRitchie" wrote:

Well to start off with printing labels is never easy from Excel, though you
would thing nothing could be simpler. But Microsoft decided that you should
print labels from MS Word.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If you do not have MS Word you will need a different solution, probably with
a lot more frustration. Or else create a text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mjcox" wrote in message ...
I hope I can explain this easily. I am using an excel document with two
columns (A and B). How can I print the labels (which are two columned) so
that Column A from excel is to the left of column B when printed onto labels.
I am trying to make it easy on myself when I go to peel the labels that I
can peel the left label and then place the right label with it. It is
different information and they cannot be on the same label. Is there a way
to do this?

If I understand the problem correctly you would use the
fields in Word in the locations that you wanted them.using the
name at the top of the column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mjcox" wrote in message ...
I understand that I have to do this as a mail merge from Microsoft Word but I
am unsure of how to do what I need to do. Maybe it cannot be done but I
thought that someone might be able to help me. I appreciate your reply. I
looked at the hyperlink that you gave but it was really no help. I just hope
that I am clear in what I am asking for.

"David McRitchie" wrote:

Well to start off with printing labels is never easy from Excel, though you
would thing nothing could be simpler. But Microsoft decided that you should
print labels from MS Word.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If you do not have MS Word you will need a different solution, probably with
a lot more frustration. Or else create a text file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mjcox" wrote in message ...
I hope I can explain this easily. I am using an excel document with two
columns (A and B). How can I print the labels (which are two columned) so
that Column A from excel is to the left of column B when printed onto labels.
I am trying to make it easy on myself when I go to peel the labels that I
can peel the left label and then place the right label with it. It is
different information and they cannot be on the same label. Is there a way
to do this?