Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a number of files in excel and i want to print the first 3 rows onto
lables but do i have to go to the hassle of using word |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I t hink you'll find that the hassle of using Word is considerably less than
the hassle of laying out labels in Excel. At least you can select the label size you wish to user is Word and it will automatically produce a table with the label layout necessary for that particular label. You can then use mail merge to retrieve the first 3 rows of data from your Excel data source. Just a suggestion... -- Kevin Backmann "Regal bath" wrote: I have a number of files in excel and i want to print the first 3 rows onto lables but do i have to go to the hassle of using word |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi,
no. lables are just another print media. excel will consider each lable as 1 "page" so you may have to play with the margins to make sure that all your data gets printed on 1 lable and doesn't bleed onto 2 lables. regards FSt1 "Regal bath" wrote: I have a number of files in excel and i want to print the first 3 rows onto lables but do i have to go to the hassle of using word |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
and with each printer and with your fonts, etc. In fact you may not
be able to line them up. There are some Excel templates to are fixed. BTW, make sure that under File, Page Setup, Page you do not have any scaling s/b 100% and pages wide and tall should be empty. Suggest you reconsider using MS Mail as that is what Microsoft provides for. For specific directions see http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- 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 "FSt1" wrote in message ... hi, no. lables are just another print media. excel will consider each lable as 1 "page" so you may have to play with the margins to make sure that all your data gets printed on 1 lable and doesn't bleed onto 2 lables. regards FSt1 "Regal bath" wrote: I have a number of files in excel and i want to print the first 3 rows onto lables but do i have to go to the hassle of using word |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
Mail Merge in Excel | Excel Worksheet Functions | |||
How do I mail merge from different excel worksheets? | Excel Discussion (Misc queries) | |||
Field missing on completed mail merge Excel - Word once merged | Excel Discussion (Misc queries) | |||
how do I use mail merge in excel for word documents | Excel Discussion (Misc queries) |