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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |