Question

Drag the fill handle ________________ or _________________ to copy the value of the selected

cell to the cells where you drag the Fill Handle.​

Answer 1

Answer:

Follow these steps:

Select the cell that has the formula you want to fill into adjacent cells.

Rest your cursor in the lower-right corner so that it turns into a plus sign (+), like this:

Cursor resting on fill handle

Drag the fill handle down, up, or across the cells that you want to fill. In this example, the figure here shows dragging the fill handle down:

Cursor dragging fill handle down

When you let go, the formula gets automatically filled to the other cells:

Values showing for cells that have been filled

To change how you want to fill cells, click the Auto Fill Options button Auto Fill Options button that appears after you finish dragging, and pick the option that want.