how to find the autofill option in excel for mac

Release the mouse button and the worksheet cells are autofilled (figure 3).Press the LEFT mouse button and drag to select the cells to auto fill (figure 2).Select (highlight) the two cells and hover the cursor over the bottom right corner until the Fill Handle (+) appears - see figure 1.Enter the first two numbers in the first two adjacent cells.Open your Excel worksheet and follow the directions below. How to Create a Linear Series with the Fill Handle

In several cases the right mouse button may need to be used, but we'll always inform you if this is the case. Release the mouse and the cells are filled. To autofill, press the left mouse button over the Fill Handle and drag over the cells to be autofilled. When you select your starting cells and hover the mouse over the lower right corner of the cell range, the Fill Handle, a plus sign, appears. How to Use the Fill HandleĮxcel's Fill Handle is a cool tool used inside the worksheet. But in each case we add or subtract the same number. has a step value of 2 because each new number in the series is 'two more' that the number before.Ī linear series can consist of decimals, decreasing values, or negative numbers. In a linear series, the next number in the series is obtained by adding a constant, or step value, to the current number.

Alternate Methods of Autofilling a Linear Series.

More Examples of Auto Fill of a Linear Series.

How to Create a Linear Series with the Fill Handle.

Read our disclosure policy to learn more. ○ This tutorial contains affiliate links.

How to find the autofill option in excel for mac