0
Click on any cell, or click and drag on any range, then release. There will be a small black square in the lower-right corner of the cell or range. That's the "copy" handle, or to give it its correct name, the Fill Handle.
If you park your cursor over that square, your cursor will change from a big white plus sign to a smaller black one. This is the copy cursor. If you click and drag to extend the range, it will do a sort-of-intelligent copy of the existing cell or range into the new area.
I say "sort of intelligent copy", because if your cell contained the word "January", it will copy "February", "March", "April", and so on. If your cell contains "Quarter 1", it will fill in "Quarter 2", "Quarter 3" and "Quarter 4" before going on to "Quarter 1" again.
If your selected range contains the numbers 1 and 3, Excel will fill in odd numbers.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
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 a replicate handle in Excel?
The Fill Handle is the proper name. It allows you copy things quickly and do fills.
The fill handle can be used to copy formulas or finish what series?
The fill-handle is a powerful tool in Excel. It can be used to copy formulas or finish a text series.
What is Continuous copy command in Excel?
A fill is like a continuous copy in Excel. It provides various ways of implementing a fill, like using the fill handle or the Fill Series options.
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.
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.
In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?
When you use the fill handle it will copy what is in the cell including the formatting.
What is used to copy formulas in Excel?
You may be referring to the Fill Handle, but there are many ways that you can copy formulas in Excel. You can do it through the menus, with the mouse, with the keyboard, with the shorcut menus, with function keys and with combinations of these options. With the keyboard alone, there are various ways you can copy formulas.
For Excel where is the copy area?
There is no copy area in Excel, but Windows has a clipboard where you can copy stuff.
What best describes the result of using the fill handle on a cell containing a formula in Excel?
It is used to copy the formula down or across.
Is there any other way to move things into a cell beside copy and paste in Excel?
You can drag things or use the 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.
