Brother QL-570 appendix Creating labels using Microsoft Excel

Page 14

Microsoft® Excel

With the Add-In function, you can directly copy text in Microsoft® Excel to a label layout.

Creating labels using Microsoft® Excel

1 Open a Microsoft® Excel worksheet and select the cells of text you want included in the label from your Excel spreadsheet.

Introduction

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 your text is displayed/printed.

When you choose 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 remove fields in this screen by highlighting the field and pressing the delete key on your keyboard.

• For details on how to automatically add the text to a Label List, see "How to add text from Microsoft® Excel® to a Label List" described on the page 15.

•If you want to include the data into the Code field of the Label List, choose [Text Imported Into the "Code" Field of the Label List] in the [Brother P-touch Import Setup] dialog box.

Creating Labels

Appendix

14	Creating Labels with Other Applications

Image 14

Contents Users Guide Contents About This Guide Symbols Used in this GuideSetup & Operation Guide Manual StructureLabel Creation Overview From Label Creation to PrintingUsing P-touchAddress Book Windows only Using P-touchEditorUsing an application from another publisher Windows only Create and print the labelStarting P-touchEditor Choose an option in the New/Open dialog Box and clickLayout window Side bar Standard toolbarProperty pallet „Snap Mode Snap mode appearsNew/Open dialog, click Help-How To Express Mode Professional ModeStart P-touchEditor Help Click Help menu and choose P-touchEditor HelpPrinting the Help description Specify the Printer item and clickRegistering and canceling the Add-In function Creating Labels with Other ApplicationsCreating labels using Microsoft Word Microsoft WordOn the Microsoft Excel standard toolbar, click Creating labels using Microsoft ExcelMicrosoft Excel How to add text from Microsoft Excel to a Label List Microsoft Outlook On the Microsoft Outlook standard toolbar, clickHow to add text from Microsoft Outlook to a Label List How to Use the P-touchAddress Book Starting the P-touchAddress BookLayout work area Text toolbarLayout style selection view Contact list combo boxClick File-New Contact. Or, click When you finish entering the data, click to storeCreating a New Contact Enter data for each itemOpening and editing data How to Use P-touchLibraryStarting up the P-touchLibrary Printing labelsSearching labels Click Search ResultsDouble click the Applications and then P-touch Editor How to use the P-touchEditor for MacStarting the P-touchEditor Layout Window Inspector„Start from New/Open dialog Choose each item and click Setting the Printer DriverPrinting Directly from Other Applications Close the Printers window Printing from Other Applications Choose Brother QL-570Close the Programs and Features dialog Uninstalling SoftwareUninstalling P-touchEditor For WindowsChoose Brother QL-570, and click Delete this printer Uninstalling the Printer DriverFor Mac Click Delete Applications-P-touch Editor 5.0 folder LED Lamp Roller maintenance MaintenancePrint head maintenance Turn the Brother QL-570 offLabel outlet maintenance Troubleshooting Potential types of problems