Click ; How Microsoft Excel data is added to the Label List; TING LA- Page 59

55

z

 CR

EA
TING LA

BELS

Using P-touch Editor with Other Applications

2

Click 

 in Microsoft Excel’s standard toolbar.

P-touch Editor starts and the Add-In Preview window appears showing the newly created label.

3

Click 

 to print the label.

„

How Microsoft Excel data is added to the Label List

A new record is automatically created for each row selected and the text in the selected data is 
added to the following fields.
• The current date is added to the Date field.
• The content of the first cell in the row is added to the Title field.
• The content of the remaining cells in the row is added to the Body field.
• If the last cell selected in the row contains numeric data and hyphens only, the content of that cell 

can be added to both the Body field and the Code field.

• Refer to P-touch Editor Help for other methods of starting P-touch Editor from within Microsoft 

Excel.

• An error message appears if there is no data highlighted, or if the data highlighted contains an object 

not supported by P-touch Editor.

• Refer to “How Microsoft Excel data is added to the Label List” on page 55 for details of how the 

selected data is automatically added to the Label List.

• Refer to Add-In Preview window toolbar on page 53 for descriptions of each button.
• When several records are selected and imported, use the Previous/Next Record buttons to preview the 

label for the previous/next record.

• If you wish to import the last column of data (if numeric) into the code field, check the "Import Into 

Code Field" checkbox on the "Add-Ins" tab of the Options dialog box.

• The maximum number of rows that can be selected and printed in a single print job is 500.
• When printing, the records selected to be printed will be counted from the bottom of the list to the 

top. To print records 1 & 2 in a list of 10, select records 9 & 10 to be printed.

To edit or customize the text or label layout, click 

.

The full P-touch Editor screen appears and you can edit the label.