To create and use a label mask method in Excel

Source: Internet
Author: User

To create and use a label mask method in Excel

1, in the daily data, equipment identification classification management, often used to label, the common is blank sticker paper.

2, when the number of labels, filling time-consuming and laborious, easy to scratch ink. Therefore, the use of printer batch printing label, is to achieve efficient office, easy office of common means.

3, Microsoft Excel has the outstanding data processing ability, the function is rich but is not yet nimble, uses it to carry on the label to play has the unique superiority.

This paper introduces a method/tool of labeling in Excel, produces the output interface with label background, realizes the batch input and print of data.

Tools/raw Materials

Document scan Map (as required)

Microsoft Excel (version 2007 or above)

Adaexcel Small Assistant (free evaluation version)

Create a Adaexcel set of easy templates

Open Adaexcel, press F11 to create a new template, select "Document Sets".

Press F2 to switch to the output interface → right button menu "interface design auxiliary" → "set template background".

According to the background of the block cell and the need to set the position of the project frame match.

Right-click menu "Interface design auxiliary" → "Area" → "Set template area"/"Set Print Area".

Debug Print:

A, set paper type, direction, in the cell input data to try to hit the label paper or copy.

B, adjust the margin, cell alignment, font size, and so on, depending on the position offset.

Right-click menu "Interface design Assistant" → "decorate background".

Press F12 to save as a standalone template file (. XLSX).

At this point, the simple template creation completes, the standard template has the more powerful function. For example, create text boxes, bulk input, and so on.

To create a adaexcel set of standard templates

The Output Interface right button Menu "interface design auxiliary" → "set continuous table".

The Output Interface right button Menu "interface design auxiliary" → "Set Item box", tick "Create Graphic text box".

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.