Skillfully using WPS form to quickly arrange entry number

Source: Internet
Author: User
Tags sort

The new semester began, with a large number of new students to enter the school, the complex number of editing and input work began. According to the Chinese custom, the traditional approach is this: let each student to the number of his surname strokes, and then according to the number of strokes from the student's surname from less to more automatic arranging. Then add in the first year, Grade (department), class, such as 06 first grade Two classes are "060102" start. Then there is a lot of input work. These tasks not only require a large amount of manpower, but also error prone. Is there a simple and quick way to do the above work? Yes, it is! Use the WPS2005 form to get you to do the work quickly and well, and to say bye bye the cumbersome and error-prone work.

First, the format study number

1. Select the student name Data area we have entered, click the Data Drop-down menu, click Sort, and click Options in the Sort tab to see Figure 1:

Figure 1

2. In the Sort Options tab, in the "Mode" column, select "Sort Strokes" Figure 2:

Figure 2

3, click "OK"

So we entered the student names by the number of strokes from less to more rows, see Figure 3:

Figure 3

Second, learn number entry

1, select the area to enter the study number, click Right I, select the format cells (F) See Figure 4:

Figure 4

2. In the Cell Format tab, select Number, category, select Custom, and in the Type column, enter 060102 00, and click OK. Figure 5:

Figure 5

3, in the A3 input "1", will automatically become "06010201". The following number can be automatically populated: the mouse to move to the lower right A3, then a "+" symbol, click left I drag down. Such a complex number of editing and typing work so easily completed, Figure 6:

Figure 6

We can also quickly enter data with common characteristics by reference to this method.

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.