如何快速处理excel数据（How to process Excel data quickly）.docVIP

如何快速处理excel数据（How to process Excel data quickly） Please dont tell me you would for EXCEL, half an hour to let you become a EXCEL Master said, more than 80% people watched this, have met earlier, would you? Believe it or not, I believe it anyway Source: Li Yipengs Journal If we use Excel XP to process huge data, we cant pay attention to techniques and methods It can take a lot of effort. Therefore, how to use Excel to input information quickly becomes Excel XP Households are very concerned about the topic... 1, quickly input a large number of decimal places If we need to enter a large number of decimal digits in the Excel XP worksheet, follow the ordinary input side Method, we may enter directly according to the size of the original number, for example, now enter the number 0.05 in the cell We will enter the 0.05 as it is in the form. However, if you need to enter a number of decimal points When we enter the above method, each time we enter a number, we need to repeat the decimal point The volume will increase and the input efficiency will decrease. In fact, we can use the decimal point in Excel XP to automatically locate the work Yes, allow the decimal points of all digits to be automatically positioned so as to rapidly increase the input speed. Using decimal point automatic positioning work On time, we can click the tools / options / Edit button first in the Excel XP edit interface with the mouse Edit tab, in the pop-up dialog box, select the automatically set decimal point check box, and then in number fine tune In the edit box, type the number you want to display on the right of the decimal point. Later, we enter the number with the decimal point Enter the number directly, and the decimal point will be automatically positioned after the enter key. For example, we want to be in a cell If you type 0.06, you can set the digit option to 2 in the settings above, and then directly in the specified cell When you enter 6 and enter, the number of the cell is automatically