Excel表格中的各类序号操纵技能(国外英文资料).docVIP

Excel表格中的各种序号操作技巧(国外英文资料)Excel in Excel spreadsheetsThe serial Numbers can be seen in various forms, and in Excel, the form is often required to enter a variety of serial Numbers, depending on the application scenario. But in practical applications, the serial number of the type is various, some will also need to use special symbols to represent, even need to input and automatically adjust the serial number, the following is to introduce a few tips about the serial number, including automatic input serial number, automatically adjust the serial number, quickly enter the serial number, custom special sequence, quickly enter the complex number.Automatic input numberAs we all know, there is an automatic numbering function in Word that automatically appends a number when you enter a sequence number. When we use Excel to compile reports or data processing, and often involves a column cell as the serial number, you dont look down upon this serial number oh, hidden inside a lot of university asked.In Word, there is a function of automatic input number, populating the sequence number column. First open the Excel file that needs to be filled with the serial number column, enter the initial value of the sequence number, and select it with the mouse. Then, double-click the filling handle below the initial value. At this point, Excel automatically detects the length of the record and sets the sequence number in order.In fact, in Excel, you have this feature, you can use functions to do that. Click A2 cell input formula: = the IF (B2 = , , COUNTA ($B $2: B2)), and then move the mouse to A2 and to the right of the cell, the mouse will turn into A shape of A cross, hold down the drag and drop to fill A column below cell, so that we in column B input, A column will automatically enter the serial number (as shown in figure 3).Automatic sequence numberSometimes we need to hide some lines for printing, only to find that the serial number is not continuous, and we need to make the seri