Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |