Brother International andtrade; QL-500 Users Manual - English - Page 58

Microsoft Excel, Open a Microsoft Excel worksheet and select the data you wish to place on a label.

Get Brother International andtrade; QL-500 PDF manuals and user guides View all Brother International andtrade; QL-500 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 58 highlights

CREATING LABELS 3 Click to print the label. To edit or customize the text or label layout, click . The full P-touch Editor screen appears and you can edit the label. „ How Microsoft Word data is added to the Label List A new record is automatically created and the text in the selected data is added to the following fields. • The current date is added to the Date field. • The first line is added to the Title field. • All remaining lines are added to the Body field. • Uncheck the "Label List" checkbox in the Add-In Preview window when you do not want to register the data in the Label List. • The data is copied onto a label formatted with the default Layout Style. To change the Layout Style, click to open the full P-touch Editor screen and edit the layout or apply a different Layout Style. Refer to "Creating Labels Using a Layout Style and Data from the Label List" on page 47 for details. Microsoft Excel You can start the P-touch Add-In and copy the highlighted data directly onto a label from Microsoft Excel. The highlighted data is copied as text and automatically added to new records created in the Label List. The Title, Body and Code fields of the new record are then merged into a new label layout, which is displayed in the Add-In Preview window. „ Creating a label using data from Microsoft Excel 1 Open a Microsoft Excel worksheet and select the data you wish to place on a label. To select the data, highlight the text. 54 Using P-touch Editor with Other Applications

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
CREATING LABELS
54
Using P-touch Editor with Other Applications
3
Click
to print the label.
How Microsoft Word data is added to the Label List
A new record is automatically created and the text in the selected data is added to the following
fields.
•
The current date is added to the Date field.
•
The first line is added to the Title field.
•
All remaining lines are added to the Body field.
Microsoft Excel
You can start the P-touch Add-In and copy the highlighted data directly onto a label from Microsoft
Excel. The highlighted data is copied as text and automatically added to new records created in the
Label List. The Title, Body and Code fields of the new record are then merged into a new label
layout, which is displayed in the Add-In Preview window.
Creating a label using data from Microsoft Excel
1
Open a Microsoft Excel worksheet and select the data you wish to place on a label. To
select the data, highlight the text.
To edit or customize the text or label layout, click
The full P-touch Editor screen appears and you can edit the label.
•
Uncheck the "Label List" checkbox in the Add-In Preview window when you do not want to register the
data in the Label List.
•
The data is copied onto a label formatted with the default Layout Style. To change the Layout Style, click
to open the full P-touch Editor screen and edit the layout or apply a different Layout Style. Refer to
“Creating Labels Using a Layout Style and Data from the Label List” on page 47 for details.