0
It can be used for a lot of things involving copying formulas or setting out patterns of values in cells.
If you have a value in a cell and drag down or across with the fill handle, it will put that value into the cells you drag down or across. If you have a formula in a cell and drag down or across on the fill handle, it will copy the formula into those cells.
If you type a day of the week in a cell and then use the fill handle to drag down or across it will start entering the subsequent days in those cells. So if you type Friday in cell A1 and then drag down, it will put Saturday in A2, Sunday in A3, Monday in A4 and so on. If you type just the first 3 letters of a day, like Fri for Friday, it will give the 3 letters for the other days when you drag down. The same thing works for the months of the year.
Type 1 into one cell and then 2 into the next cell. Select both cells together. With the two cells selected, using the fill handle you will get 3, 4, 5, 6 and so on in the subsequent cells. You can also get a set jump between values in a similar way. So if you put 1 in a cell and 4 in the next cell and then selected both and filled down it would continue with 7, 10, 13 and so on.
You can also use the fill handle to clear cells. Put a list of values into several cells. Select all the cells. Then, using the fill handle, drag back across the values and it will delete the ones you drag across.
Wiki User
∙ 14y ago
Wiki User
∙ 10y agoIn the bottom corner of the active cell you will normally see a small black square. This is the fill handle. Using it you can do various kinds of copying and filling activities. Normally we just put the cursor over it and drag down or across and whatever is in the cell will be copied to the other cells. It can also be used for other things. If you type in a day of the week or month of the year and drag down, it will fill out the following days or months. There are many other things it can do too.
Wiki User
∙ 14y agoIt is a small square at the bottom right of a selected cell.
Wiki User
∙ 14y agoAuto fill allows Excel to identify and fill a series of text or numbers, automatically, in a given range. See related links for more details about Auto-Fill.
Wiki User
∙ 8y agoIt is like a small square on the bottom right corner of the highlight around the active cell.
Add your answer:
Earn +20 pts
Name of the square in the lower-right corner of a selection that is used to copy cells in Excel?
The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.The Fill Handle.
What is the small black square located in the lower-right corner of the heavy border around the active cell?
It is the fill handle, enabling you to drag down a cell with a formula or for extending pre-defined lists. For example: if you type Sunday into a cell and press return, and then use the fill handle to fill down, it will automatically put in the other days of the week. You can do the same for Months.
What does the fill handle look like?
The fill handle in excel looks like a thin black cross
A small black square in the lower corner of an active cell called?
Fill Handle
How do you delete fill handle in Excel?
The fill handle can be turned off in the Excel options, though it is more useful to have it on.
Is fill handle used to copy contents in Excel?
A fill handle can copy anything and in different ways. It can copy contents and it can copy formulas and it can create fill series.
What is the fill handle?
Sum
When the active cell contains a formula dragging the fill handle causes excel to?
Copy the forumula to the cells where you drag the fill handle.
Can the fill handle create a series of numbers or dates?
Yes, you can use the Fill Handle to drag down and create a sequence of dates.
When the active cell contains the formula dragging the fill handle causes Excel to?
Copy the forumula to the cells where you drag the fill handle.
How do you fill in multiple excel cells with the same information?
Use the "fill handle", to fill down or across.
As you drag the fill handle you will see?
The fill handle is a tool used in Microsoft Excel. It has various uses in terms of the way it can copy things, so you may see different things on different instances of you using it. As you drag the fill handle, you will see an outline of the area that is to be filled. You may also see values in tip text form beside the fill handle. When you stop dragging, the cells will be filled and you may then see the Autofill icon beside the fill handle.
