Shulou(Shulou.com)11/24 Report--

Original title: "Excel input data, you are definitely not as fast as I am!" "

When it comes to entering data, you must not be as fast as I am, because I have mastered the skill of "digital format", and the input efficiency is not covered, so let's take a look at it together.

1. Enter gender quickly. Enter male and female gender quickly.

Completion: enter 1 to display "male" and 2 to display "female".

Custom format: [= 1] "male"; [= 2] "female"

2, quickly hook √ × in many tables, we will use special symbols √ and ×, but this special symbol input is particularly troublesome. If we use a custom format to enter, it will be too easy.

Completion effect: input 1 will automatically become "√", and input 2 will become "×".

Custom format: [= 1] "√"; [= 2] "×"

3, fast input units often enter some data will be followed by a variety of units, these units really do not need to add manually.

Completion effect: entering any data will automatically add the unit "yuan" and retain two decimal places.

Custom format: 0.00 "yuan"

4. we can also omit the repetitive content and only enter different contents into the class quickly. For example, here I need to enter a lot of classes, you can set the custom format to "third grade @ class", in which the "@" will show the content we entered, the front and back are the same content.

Completion effect: if you enter 1 in the cell, it will automatically display "Class 1, Grade 3"; if you enter Class 2, it will show "Class 2, Grade 3".

Custom format: third grade @ class

5. How to quickly input QQ Mail into the mailbox? Where is the rule?

Completion effect: only enter the front part of the mailbox, and the @ qq.com content will be generated automatically.

Custom format: @ "@ qq.com"

6. Enter segment numbers We often enter phone numbers or bank card numbers in the form. This type of number will be easier for us to view if it can be displayed in sections, and it will be slower if we enter it manually one by one.

Completion effect: enter the mobile phone number or bank card number will be automatically segmented display.

Custom format: 000-0000-0000

Rapid entry of product numbers consists of a string of the same letters or data in front of them. using this rule, we can also enter numbers quickly through a custom format.

Completion result: input 1 will automatically display "Amur0001".

Custom format: "A -" 0000

8, quickly enter pass, fail, how to quickly grade the students' grades? Quickly write passes and failures after the grade?

Completion effect: enter 1 to show green "pass", and enter 2 to show red "fail".

Custom format: [green] [= 1] "pass"; [red] [= 2] "fail"

9. Enter the amount displayed in ten thousand yuan if the data entered is relatively large, we can change the data to "ten thousand" as a unit, which may be more intuitive.

Completion effect: the input data will automatically add "ten thousand" and retain one decimal place.

Custom format: 0room.0, "ten thousand"

10. Quick input Custom date format when many friends enter a date, they enter it like this: 2020-01-01. Actually, it doesn't have to be so much trouble. We can select a date type from "right"-"format cells"-"numbers"-"dates".

Completion effect: enter 1-1, you can quickly complete the input date.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.