Purchase Windows and Office keys with the discount code [KSW35]

Enjoy preferential price + extra 35% off = up to 90% DISCOUNT!
Take a Guess to Get Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to AutoFill the Arithmetic Sequence in Microsoft Excel

Date:2019-10-9 Author:Cordelia

Using AutoFill in Excel, you can quickly fill the same sequence or the sequence with a tolerance of 1 directly. But what if the tolerance of arithmetic sequence you need to fill is not 1? In fact, Excel enables you to customize the tolerance and fill the arithmetic sequence automatically. Let’s see how to do it.

1. Open an Excel sheet, enter the initial value in any of the cells.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

2. Select all the cells you want to fill in the arithmetic sequence.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

3. Find Fill button in Home tab. Choose Series… in the drop-down list.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

4. Check Linear in Type and enter the tolerance beside Step value. Then hit OK to implement it.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

5. Now the arithmetic sequence is filled automatically.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

6. You can also enter a negative nubmer in Step value.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

7. Thus you can fill a decreasing arithmetic sequence quickly.

How to AutoFill the Arithmetic Sequence in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *