填充柄

填充柄 Function and function of Excel filling handle In the daily use of Excel, we often have to fill some of data with a series of operations, so I will use the Excel filling handle all cases, summarize the contents of written articles, on the Excel basic knowledge in the column, perhaps, have you not used the function of oh! 1, first of all to explain what is the Excel fill handle. In Excel help, the definition of the fill handle is: the small black box located in the lower right corner of the selected area. When the mouse is pointing to the fill handle, the mouse pointer is changed to black cross. Maybe so long Excel you haven't noticed this a little detail, in our choice of regional, regional selection around the border will be bold, while in the lower right corner of a frame of a larger piece of black, which is filled with Excel handle. 2. What is the function of the Excel filling handle?. From the name we can see that the filling handle is used to fill the data, but in some cases, it can also complete the function of cell contents and delete insert cells, the following will detail. 3, how to use the filling handle?. Maybe it's bullshit! But let me explain. Move the mouse to the filling handle, when the mouse is changed from a cross to a fine black cross, then you can use the fill handle to do the top and bottom dragging operations. 4 、 enable and disable the fill handle. Maybe nobody will notice that the filling handle can be disabled, because in general, the fill handle is available, and we won't disable it. If you don't want to have this feature (usually not), or when you find that the fill handle is not available, you can edit the card in the tools / options and set it in the cell drag and drop function. If it's version 2007, you can click the Office button, and in the bottom Excel option, the advanced enable fill handle is set with the cell drag and drop function. The above illustrates the basics of the Excel filling handle, so let's explain the functions of the padding handle. 1, left key filling. When we select a data area, with the left mouse button to use the fill handle, probably because the choice of regional and drag a different direction to produce different results. 1) select a single cell to drag and drop. When the selection area is populated with a single cell, the default padding of the Excel is the copy cell, which fills the contents and formatting of the selected cell. 2) select one column, multiple columns. When choosing the area for the single columns, if the fill is left or right, filling of Excel is copied cells; and if it is down, filling of Excel is the way to fill and sequence data, the cell and the sequence of the benchmark is the original choice; if it is filled up, at this time the function is to remove the original contained in the selected area, and not included in the current selection in the area of numerical. Maybe this passage is a bit boring, but you should understand it immediately if you move it. 3) select multi line, single column and multi row, multi column case, you can see the instructions in two, and then operate it, you can understand. After the ExcelXP version, the operation has been done, The lower right corner will generate an automatic filling option, then we can also be a choice of them, to modify the filling operation just now, if you look at the operation, combined with the automatic filling of the default, you should better understand the contents of the above. 2, Ctrl+ left padding. Before filling, when you release the left key, if you hold the Ctrl button first, then leave the left key, then the padding will be the default. That is, the default is to copy cells, which are filled in sequence, and vice versa. 3, Shift+ left padding. In the filling time, if you hold the Shift key, then you can find that the shape of the mouse will be under the direction of two = number plus key (do not know how to express more appropriate, then fill handle) function, are also inserted or deleted cells. When drag and drop makes the selection larger, the function of the operation is to insert cells that increase the area; and when the decrease occurs, the corresponding cells are deleted. 4, right-click filling. If you use the right to fill in the operation, release the right button, will pop up a menu, this menu in addition to conventional options, as well as for the date of the option and the geometric or custom sequence filling options. When the selection area is multiple or multiple columns, if the drag and drop operation causes the selection region to change, the function is equivalent to clearing the cell's value. 5, double click on the left fill. When the data to be filled has many rows, double-click the fill handle often simplifies the operation; of course, these operations can also be done with the shortcut keys. 1) when the cell below the selection region has no content, Excel will automatically populate the next content line with the contents of the column on the left of the selected area, or be the same as the contents of the column on the left. 2) when there is content in the lower cell of the selection region, the Excel automatically fills the content boundary in the selection area. Here, fill the role and function of the handle of the contents of the above summary, you have not used it, if any, as soon as the practice of learning about it *~_~*, if you feel useful, then introduce it to friends. We know that when using the Excel input data, often have to input a lot of continuous or discontinuous data, such as the number of students, the number of goods and so on, if the use of the manual input method, it will be a very cumbersome and error prone things, if we use the Excel in the fill handle method can quickly and easily the input of many continuous or discontinuous data. The so-called "fill handle" is a small black block in a certain area in Excel (Figure 1), and if the mouse points to it, the shape of the mouse becomes a black cross. Drag the fill handle to copy content into adjacent cells. Here to enter the discontinuous number of students and continuous number of students as an example, respectively introduced the use of "filling" the "drag" filling several methods: First, create a custom fill series, enter the first number, and then use the fill handle drag (applicable to large, continuous or discontinuous data): if you often enter large and the number and number of discontinuities, such as a number of different school year etc., You can create custom sequences, as follows: First of all, please select "tools / options" in the pop-up menu, the options dialog box, click the custom sequence list box in the "new series" option, and then in the input sequence to edit the list box, from the first sequence (here can input 98001~98010, 99001~ 99010 and other elements began to enter a new school) sequence. After typing each element, press the Enter key. When the entire sequence is finished, click the add button. Custom sequences can contain text or with numeric text. If you want to create a custom sequence contains only numbers, such as the "Id", is the custom in the input sequence, the "Id" before also need to select the empty cell enough (usually a column can be selected), and on the format menu, click the "cell" command, and then click the "digital" the application of Text Format tab, empty cell selected, finally set in sequence input format of the cell. This case should be in the A2 cell type 98001, A2 will move the mouse to the lower right corner of the cell (fill handle position), you can see the cursor changes to a black cross, then press the left mouse button and drag down to the specified location can be released (see Figure 2). The use of this method should pay attention to is: must first custom serial number; we must set the column format for text format (such as the serial number is not included in the text, because when the input contains text data automatically default to Excel text format). Tips: Please input the Western single quotes "'" then enter the student ID: 98001 (for more than 15 of the input digital input, such as the new version of "digital identity card number is not involved in the calculation of the occasion), digital input format that automatically changes to the text format, can be directly used to drag the fill handle and this is a very simple method. Two, manual input first and the 22 adjacent "Id" and then use the fill handle drag (for continuous digital): such as: first the A2 cells in the A3 cell input 98001, input 98002, then use the mouse to select A1 and A2 directly after the movement of the mouse to A3 single cell on the right corner (fill handle position), when the mouse has become a black cross (see Figure 3), you can press the left mouse button and drag down to the specified location can be loosened. Three, manual input the first number, using the "Ctrl+ drag the fill handle combination (suitable for continuous digital, recommended to use this method): from the above figure 2 and figure 3 can be found in the 98001 figure two in a cell number position is not the same as in Figure 3, 98001 in the right side of the cell is. The conventional digital format (the default format state number is on the right side, but you can change), 98001 in the cell on the left side of Figure 2, text format (text is the default state is on the left side, also can change). Because Excel automatically default to a digital format in digital input, so the above two methods, if you do not enter so many "Id" often, the author thinks that the second kinds of practical method, the first method is more troublesome, but often repeated, not applicable to input consecutive numbers (multiple year school), everyone can be selected according to the needs or habits. The following is a more simple method: first the A2 first input number 98001, A2 will move the mouse to the lower right corner of the cell (fill handle position), when the mouse into a black cross, then hold down the Ctrl key (you can see the black cross right corner there is a small black cross, see (Figure 4) and then press the left mouse button and drag down to the specified location can be loosened. When using Excel 2003, we may often use Excel 2003's data filling capabilities to improve our productivity. The use of filling function is generally divided into two kinds: one is data replication; the other is sequence filling. This article mainly introduces how to use them. Methods: a replication sequence arithmetic and filling The method is usually used to input values in a cell, such as "1", and then move the mouse to the lower right corner of the cell, the mouse into bold "+" button, drag the mouse to the row or column of a cell, release the mouse after the value "1" replication to other cells. If the cell is on the left side of the continuous area, can also directly double-click the mouse, will automatically copy the data to the end of a continuous cell; if you hold down the Ctrl key while dragging in the process, the arithmetic sequence of filling, such as "2,3,4......" ; Method two: continuous replication Input "in two consecutive cell 1,2, move the mouse to the" 2 "in the lower right corner of the mouse into the bold" + "button, drag the mouse to a cell, it will be the way of filling arithmetic sequence, such as" 3,4,5,6 "; if you hold down the Ctrl key while dragging in the process. It will be copied to other cells to replicate the numerical form, such as" 1,2,1,2,1,2"; Method three: use the sequence dialog box After you enter the value "1" in the unit, select Edit > fill > sequence, and you can make more choices in the pop-up dialog box. You can choose "series produced in a row or column", can choose the type of filling, or is the arithmetic geometric, date or automatic filling, can choose the date of the unit, according to our request to set the step value, the last value can set the size of the filling, eliminates the need to choose a large area; Method four: right drag sequence The sequence dialog box provides more options, but you need to select the menu to execute, which is tedious to use many times. In fact, this function also has shortcuts. We also enter values in the cell, dragging the mouse to the lower right corner of the cell, but during the drag, be careful to hold the right mouse button instead of the left. Drag to the right position to loosen the right button. Select the same options as the sequence dialog box on the pop-up shortcut menu. And is it easier to add options with formatting?! Method five: Custom sequences Several methods introduced above are mainly for filling numerical sequences, so how to fill the text sequence, which involves the custom sequence. In Excel 2003, Has built a number of text sequences, such as common week, heavenly stems and earthly branches. After we enter "Monday", drag "mouse" to appear "Tuesday, Wednesday..." and so on. This setting provides us with great convenience, can we often use the name, Department, and other custom classification method into a sequence, input only need to input the first phrase, drag the mouse can be realized after filling all phrases. To customize the text sequence, select Tools > Options > Custom sequences, enter text sequences in the right field, or select them directly from the worksheet area. Left key 1, custom sequence filling. 2, copy cells: Situation 1. The data in the cell is pure Chinese characters. You can select two or more units at the same time. When you fill the handle, drag the left key. Two. Case two, the data in the cell is pure numbers, can only select a cell, fill the handle appears, drag left to complete the copy. Case three, the data in the cell is the collection of Chinese characters and numbers, select the cell, press and hold the CTRL key, when the fill handle appears, drag the left key to complete the copy. 3, the arithmetic sequence filling: A, select the two or more cells that have entered the number. When the fill handle appears, press left to drag the two. B, a special code (code) filling arithmetic sequence: 001-050 generated directly in a cell type in 001, place the mouse pointer appears in the lower right corner of the cell after the fill handle, drag the left button. 4. Fast filling of formulas and functions. 5, the date is filled by days. Note: if there are data on the left side of the column in operation, you can double-click the left button to implement the above function (copy the cell, three exception). Two, right key 1, copy cells 2. Populate in a sequence 3, sequence: arithmetic sequence and geometric sequence.