User`s guide

800.788.5572 DuraLabel.com

LABEL DESIGN

Start by opening an Excel document, placing column headers in the first row (Fig. 1).

For this example we use Part Numbers and Descriptions (Fig. 2).

A. Enter your first two sequential numbers in cells A2 and A3 (Fig. 3). Select cells

A2 and A3 and place your cursor over the little box in the lower-right corner of the

selection. Your cursor becomes a “+.” Now click and drag the selection down the

number of cells equal to the number of labels in the sequence (Fig. 4).

B. All the column’s numbers will sequence the same as the sequence used in the

first two rows (Fig. 5). This example reflects 10 labels, with a sequence of 1.

C. Now enter the data for Column B, e.g., Descriptions, that relates to the data in

corresponding rows of Column A (Fig. 6).

FIGURE 1 Blank Excel document

FIGURE 2 Excel document with headers

FIGURE 4 … then drag your

cursor the number of cells

equal to the total number of

labels in your sequence.

FIGURE 3 Enter two rows of

numbers …

FIGURE 5 The

spreadsheet reveals

plans to print 10 labels,

with Part Numbers

sequenced by 1

FIGURE 6 Enter data under

Column B that relates to the

data on the corresponding row

of Column A.