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

Xiao E knows quite a lot of cousins, understands all kinds of function formulas without fear, uses them very skillfully, and makes charts easily.

It's just that when you make a simple statistical table, you hear them complain frequently-- how troublesome is it to enter data?

Trouble? The one who likes to help the little sisters solve the trouble most is the little E me! I hurriedly leaned over. It turned out that it was Sister Mei Wen who wanted to enter the intern's information ↓.

"after pressing enter, the mouse goes to the next line, but it is more convenient to enter from left to right. Do I have to reach out and move the mouse every time? "

"enter your mobile phone number in stages, do you have to manually add a short bar each time? Is there any way to save trouble? "

"where the salary should be written on the unit, but if the unit is written down, it will not be able to calculate the sum automatically? "

……

All right, Sister Mei Wen, Xiao E will tell you all the tips that are easy to use when entering data to help you get rid of these troubles!

Fast horizontal data entry here it is more convenient for Meiwen to enter information line by line, that is, she hopes that after entering each cell, she can go to the cell on the right to continue typing.

However, we all know that when you press enter (that is, the [Enter] key) to enter the data in Excel, it goes to the cell directly below.

Press the [Tab] key, the direction of movement is the right, but after all, many people are accustomed to press enter, but not used to pressing the [Tab] key.

Is there any way to change the direction of the enter key?

That's for sure! Click [File]-[options]-[Advanced], check "move the selection after pressing Enter", and change the direction to "right".

Be sure to try it! Next time, you don't have to force yourself to change your habits or touch the mouse!

Drop-down menu quickly enter fixed items every time you fill in the gender information of the person, you are still tapping "Annan" by hand? It's so low!

Using the "data Verification" function to make a drop-down menu is actually a common feature, and the steps are as follows:

Note that the options entered here in "Source" in step ❹ are separated by English half-width symbols, and finally click "OK".

For some content, such as "gender", the contents to be filled in are fixed options, so you might as well make a drop-down menu, which can not only improve the speed of data entry, but also play a role in standardizing input.

When entering "school" information quickly, because the names of many schools are not short, you always have to type in a lot of words. in addition to making a drop-down menu, have you ever imagined that you can enter information quickly just by typing the initials?

The steps are as follows:

Click * * File * *-> * * options * *-> * * proofread * *-> * * autocorrect options * *, and fill in the abbreviations and full names. Let's see the effect, ↓.

Correctly enter ID card information input and normal display ID card number, is a clich é topic, review it again.

The method is to change the cell format from "number" to "text"-- it can be that each time you enter an ID number, enter the English single quotation mark ↓ first.

Or select the input area first, press [Ctrl+1] to quickly bring up the "format Cell" window, change the cell format to "text" and then enter the data into ↓

Segment display of mobile phone numbers if there is no separation between 11-digit mobile phone numbers, it is easy for us to misread them when looking them up. Then how can the mobile phone number be displayed in segments as it is typed?

You don't have to type the crossbar manually! First select the area where you want to enter data, [Ctrl+1] quickly call up the "set Cell format" window, and change the "G / General format" to "0000-0000-0000" in [Custom].

When you type your cell phone number again, this effect will appear automatically, ↓.

In addition to the drag-and-drop operation, there is also a very convenient method, ↓, for bulk entry of the same data.

[Ctrl+Enter], please remember this shortcut key!

Add units to the data and be able to calculate that if we add units to the data directly at the time of entry, we will find that there is no longer the sum of numbers in the lower right corner, but becomes the count of cells.

What can be done to make the data participate in the calculation and display the units at the same time?

Select the area where you want to enter data, bring up the window for cell formatting, type "meta" directly after "G / Universal format" in Custom, and click "OK".

In this way, when we enter the data, we can automatically bring the unit after typing the number, and it will not affect the calculation!

Sister Mei Wen said that after listening to Xiao E introduce these data entry tips, I no longer feel that this job is so troublesome!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Coco, Editor: Zhu Lan

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.