Brother International andtrade; QL-500 Software Users Manual - English - Page 29

Microsoft Excel, Creating labels using Microsoft Excel

Page 29 highlights

Introduction Creating Labels (For Windows) Microsoft Excel With the Add-In function, you can directly copy text selected in Microsoft® Excel to a label layout. Creating labels using Microsoft Excel 1 Open a Microsoft® Excel worksheet and select the cells that contain the text you want to include on the label. 2 On the Microsoft® Excel standard toolbar, click . The [Brother P-touch Import Setup] dialog box appears. 3 In [Label Layout], make adjustments to the line feed in the cells and click . [Label Layout] enables you to change the way a label will be done its layout. When you select any listed item in the [Fields] box and click , a new field is added to the [Label Layout] box. You can enter spaces, line feeds, commas, and characters for each cell and print them on a label. You can also preview the layout in the [Label Preview] box. The Add-In Preview window appears. Creating Labels (For Macintosh) Appendix 29 Creating Labels 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

Creating Labels with Other Applications
29
Introduction
Creating Labels (For Windows)
Creating Labels (For Macintosh)
Appendix
Microsoft Excel
With the Add-In function, you can directly copy text selected in Microsoft
®
Excel to a label layout.
Creating labels using Microsoft Excel
1
Open a Microsoft
®
Excel worksheet and
select the cells that contain the text you
want to include on the label.
2
On the Microsoft
®
Excel standard toolbar, click
.
The [Brother P-touch Import Setup] dialog box appears.
3
In [Label Layout], make adjustments to
the line feed in the cells and click
.
The Add-In Preview window appears.
[Label Layout] enables you to change the
way a label will be done its layout. When
you select any listed item in the [Fields] box
and click
, a new field is added to
the [Label Layout] box.
You can enter spaces, line feeds, commas,
and characters for each cell and print them
on a label.
You can also preview the layout in the
[Label Preview] box.