填充柄（Filling handle）.docVIP

填充柄（Filling handle） 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 havent 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 its 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 wont disable it. If you dont 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 its 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 lets explain the fun