TJ-4020TN
FAQs & Troubleshooting |
How to add Microsoft® Excel text to a Label List (P-touch Editor 5.x for Windows)
For TD-4T / TJ-4T series:
To use P-touch Editor, download and install “Printer Driver for P-touch Editor” from the [Downloads] section of this website.
To add Microsoft® Excel data to a Label List, the Label List has to be set to record the data.
If it is NOT set, please take the steps below:
- Click [Tools] - [Options...] in the edit screen.
- Click the [Label List] tab.
- Check the "Automatically Record Data Imported With Add-In" check box ON.
- Start Excel, and then open the document containing the data to be imported.
- Select the cells to be imported.
- Click the "Brother P-touch" button on the [Add-in] tab of the Ribbon.
The imported data will be registered in the Label List as follows:
Label Data |
Column |
Date Created | "Date" field |
First line of the highlighted information | "Title" field |
All highlighted information | "Body" field |
Text set to be imported into the "Code" field | "Code" field |
Related Models
MW-140BT, MW-145BT, MW-260, PT-9700PC, PT-9800PCN, PT-D600, PT-D800W, PT-P700, PT-P710BT, PT-P750W, PT-P900W/P900Wc, PT-P950NW, QL-1050, QL-1050N, QL-1060N, QL-1100/1100c, QL-1110NWB/1110NWBc, QL-500, QL-500A, QL-550, QL-560, QL-570, QL-580N, QL-600, QL-650TD, QL-700, QL-710W, QL-720NW, QL-800, QL-810W/810Wc, QL-820NWB/820NWBc, RJ-2030, RJ-2050, RJ-2140, RJ-2150, RJ-3050, RJ-3150, RJ-3230B, RJ-3250WB, RJ-4030, RJ-4040, RJ-4230B, RJ-4250WB, TD-2020/2020A, TD-2120N, TD-2125N, TD-2125NWB, TD-2130N, TD-2135N, TD-2135NWB, TD-4000, TD-4100N, TD-4210D, TD-4410D, TD-4420DN/4420DN(FC), TD-4420TN, TD-4520DN, TD-4520TN, TD-4550DNWB / 4550DNWB(FC), TD-4650TNWB, TD-4650TNWBR, TD-4750TNWB, TD-4750TNWBR, TJ-4020TN, TJ-4021TN, TJ-4120TN, TJ-4121TN, TJ-4420TN, TJ-4422TN, TJ-4520TN, TJ-4522TN, TP-M5000N