20.5k views
4 votes
How do you use the fill handle to fill the empty cells from G3:G11?

1) Drag the fill handle from G3 to G11
2) Right-click on G3 and select 'Fill' from the menu
3) Press Ctrl + D after selecting G3:G11
4) Double-click on the fill handle in G3

User Zacronos
by
7.8k points

1 Answer

5 votes

Final answer:

To fill empty cells from G3:G11 using the fill handle, drag it from G3 to G11 or select the range and either right-click on 'Fill' or press Ctrl + D.

Step-by-step explanation:

To use the fill handle for filling empty cells from G3:G11, you can either drag the fill handle from G3 to G11, or first select the range G3:G11, and then either right-click on G3 and choose 'Fill' or press Ctrl + D. But the most efficient option specifically for filling down a series or copying the value of G3 down to G11 is to drag the fill handle from G3 to G11. The fill handle is a small square at the bottom-right corner of the cell pointer. When you select G3, this fill handle appears. To drag it, click the fill handle and drag it down to G11. Alternatively, if you double-click on the fill handle, it will automatically fill the cells for you based on the continuous range of cells next to the column.

User Mauren
by
7.3k points