Brother QL-1050N User's Guide download pdf (Page 29)

Creating Labels with Other Applications

IntroductionCreating Labels (For Windows)Creating Labels (For Mac)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 your selected text is displayed/printed.

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.

• For details on how to automatically add the selected text to a Label List, refer to "How to add

Microsoft

Excel text to a Label List" described below.

• For details on the Toolbar of the Add-In Preview window, refer to Î"Toolbar in the Add-In

Preview window" on page 27.

• If you want to include the data into the Code field of the Label List, select [Text Imported Into the

"Code" Field of the Label List] in the [Brother P-touch Import Setup] dialog box.

• When multiple records are selected in Excel, use the buttons to show the other lines.

1 2 ... 24 25 26 27 28 29 30 31 32 33 34 ... 66 67

No comments

Brother QL-1050N User's Guide Page 29