68.8k views
1 vote
Use AutoFill to complete the series from cell B7 through cell E7.

1 Answer

4 votes

Final answer:

To use AutoFill to complete a series, enter the starting value and drag the fill handle.

Step-by-step explanation:

To use AutoFill and complete the series from cell B7 through cell E7, follow these steps:

  1. Enter the starting value in cell B7.
  2. Click and drag your mouse from cell B7 to E7, highlighting the range.
  3. Release the mouse button, and a small square will appear in the bottom right corner of cell E7, called the fill handle.
  4. Click and drag the fill handle down to fill the cells below with the desired pattern.

For example, if the series is 1, 2, 3, 4, you can enter 1 in cell B7 and then drag the fill handle down to automatically fill cells C7, D7, and E7 with the subsequent numbers.

User NoDakker
by
8.7k points