Graphic Products DuraLabel 7000, Руководство пользователя

Страница: 18 / 32

18
2. Because Excel uses pixels to measure rather than inches, it is
necessary to format Word documents accordingly. Go to Tools >
Options to bring up the property sheet for Word. In the General
tab, find the option to change the unit of measure. Change it to
Point (which is the same as pixel).
3. If a template is already loaded, make a note of its width and
height. These values are needed to set the cell size in the Excel
template. When starting with a completely new Word document,
go to
File > Page Setup > Paper and set the width and height to
the desired label size.
4. It is now time to add text. Keeping Word open, browse to the
provided Excel template: Number Sequence.xls .
This is a predefined template with the formula already in place to
increment a numeric value by one.
1. Open the existing Excel template
Number Sequence.xls .
2. Format the cells to match the label size set in Word: Click on the
upper left corner of the spreadsheet to highlight the entire
document.
3. Left-click and hold the column line between A and B. There will
be a small box showing the width in pixels. Adjust the column
width to make it the same as label. Repeat for Row Height.
4. Now that the cell size is set to match the label size, change the
value in the first cell (column A, row 1) and enter the desired text.
In the next cell (column B, row 1), enter the number to be
incremented. In the next cell (column C, row 1) enter the value of
the increment. The default is 1.
After entering this information, the increment should be visible in each cell below
cell 1. Example: To increment the value 100 times, drag the cells down to the
100
th
row.
5. Once the desired increment and cell span are set, copy the cells
to the Word template. Remember that the Word template must
match the size specified in the Excel template.
Select the entire Excel column by clicking on the top header of
the cell (in this case, A). Go to
Edit > Copy to copy the entire
column. In the Word document, click anywhere inside the
defined page and go to
Edit > Paste . If the cells don’t paste into
the exact measurements of the label, adjust the margins so they
encompass the entire label.