用excel xp轻松输入成绩（用excel xp轻松输入成绩）.docVIP

用excel xp轻松输入成绩（用excel xp轻松输入成绩） Wang What is the brand teachers most headaches? Of course is the entry of student achievement, although it has been in the burden, but necessary statements or not, if only one class is OK, if you have 3 classes and 5 classes, the achievements of the input is not easy, it is cumbersome and error prone, today, the author combines the characteristics of performance input, introduces using Excel XP techniques for increasing input efficiency: Which was 1. in the English input automatic switch The brand we are usually in Excel XP (the skills in Excel 97) also applies to input student achievement, of course, most of the time are input numbers, but also sometimes some Chinese characters such as input, the subjects of the results are generally excellent / good / pass / fail four grades, the operation level assessment is generally excellent / good / standard / not to meet the standards, these are Chinese characters. Therefore, when you enter different types of data, you have to constantly change the input method, a little English, and a little Chinese, very troublesome. Which was in fact, we can use Excel XP implements automatic switchover of input methods in different cells. First select a range of cells to enter Chinese characters, and then from the data menu to perform the effectiveness command in data valid window select input mode tab, in the mode drop-down list box select open mode (Tutu 1), and then click ok. Then, to select a range of cells to input the numbers, also open the data validity window input mode tab, but this time is the need to select off (English mode) mode, click OK button to end setup. Which was so set, when the insertion point in different cell, Excel XP will automatically switch between Chinese and English input methods according to your settings. The Chinese input method chosen here depends on your settings in the control panel / input method. AP 2. automatic filling quickly enter duplicate information Improving the