Microsoft Excel | Brother QL-570 guide

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

Brother QL-570 appendix Creating labels using Microsoft Excel, On the Microsoft Excel standard toolbar, click

Contents

Users Guide Contents About This Guide Symbols Used in this GuideSetup & Operation Guide Manual Structure Label Creation Overview From Label Creation to Printing Using P-touchAddress Book Windows only Using P-touchEditorUsing an application from another publisher Windows only Create and print the label Starting P-touchEditor Choose an option in the New/Open dialog Box and click Layout window Side bar Standard toolbarProperty pallet „Snap Mode Snap mode appears New/Open dialog, click Help-How To Express Mode Professional ModeStart P-touchEditor Help Click Help menu and choose P-touchEditor Help Printing the Help description Specify the Printer item and click Registering and canceling the Add-In function Creating Labels with Other Applications Creating labels using Microsoft Word Microsoft Word On 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, click How to add text from Microsoft Outlook to a Label List How to Use the P-touchAddress Book Starting the P-touchAddress Book Layout work area Text toolbarLayout style selection view Contact list combo box Click File-New Contact. Or, click When you finish entering the data, click to storeCreating a New Contact Enter data for each item Opening and editing data How to Use P-touchLibraryStarting up the P-touchLibrary Printing labels Searching labels Click Search Results Double 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-570 Close the Programs and Features dialog Uninstalling SoftwareUninstalling P-touchEditor For Windows Choose 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 off Label outlet maintenance Troubleshooting Potential types of problems