Importing from Excel Spreadsheets
How to transfer Excel spreadsheet information into a Word label
Note: These instructions are for users of Windows 2000. If you are using Windows
XP, please follow the directions on page 37.
A. Merging
One Column
from a Spreadsheet to a Label:
1)
First, make sure the Excel file you are going to merge has been saved.
2)
Open up the Word Document with the label template.
3)
Alter the font in Word to the size of your choosing.
4) Open up the Excel file you intend to merge into the Word label.
41
Once you're satisfied with the amount of increments and cell span, its time to copy
this into your
Word
template. Go back to the word document that you previously
created.
!!Remember!!
The page layout of the
Word
template must match the cell
size you specified in your Excel template.
Select the entire Column you just created by clicking on the top header of the cell. In
this case, the "A". Go to
Edit >>> Copy
, to copy the entire column. Now switch over
to your
Word
document, click anywhere inside your predefined page and go to
Edit
>>> Paste
.
If the cells don't paste in exactly to the measurements of your label, adjust the mar-
gins so that they encompass the entire label.
You should be ready to print.
40
Содержание 4 TTP
Страница 1: ...DuraLabel 4 TTP User s Guide ...