How to use the Range feature – AutoFill Excel

I see that these days, office-related articles like Word and Excel have been viewed and received by many brothers and sisters. So, I will make a series of instructions to guide you to use Excel in full through 300 brief Excel examples below.

Introduce

I. Range

1. AutoFill

Use AutoFill in Excel to autofill the cells you want. You can see the examples below.

1. Enter 10 in cell A1 and 20 in cell A2.

2. Select cell A1 and cell A2 drag the small square in the lower right corner. The cells below will automatically fill in the exponential value of the 2 cells you select.

3. Enter Jan in cell A1.

4. Select cell A1 and drag it down. AutoFill automatically fills in the next month names.

5. Enter Product1 in cell A1.

6. Select cell A1 and drag it down. AutoFill will automatically fill in the next numbers.

7. Enter Friday in cell A1.

8. Select cell A1 and drag it down. AutoFill will automatically fill in the next date names.

9. Enter January 1, 2019 in cell A1.

10. Select cell A1 and drag it down. AutoFill will automatically fill in the following dates.

11. Instead of entering the date, use AutoFill option to fill in the days of the week (ignoring weekends), months or years.

12. Enter April 1, 2019 in cell A1 and January 1, 2019 in cell A2.

13. Select cell A1 and cell A2 and drag down. AutoFill will automatically fill in the next dates based on the 2 selected cells (7 days apart).

14. Enter the time 6:00 AM in cell A1.

15. Select cell A1 and drag to the right. AutoFill will automatically fill in the next intervals.

16. When Excel doesn’t recognize the list you want, just create one custom list here.

17. Uses flash fill in Excel 2013 or later to automatically extract or automatically combine data.

If you use Excel 365, you can also use the SEQUENCE function to populate cells. This function is quite interesting.

18. The SEQUENCE function below creates a two-dimensional array. 7 rows 4 columns, starting at 0 and spaced 5 units apart.

19. The SEQUENCE function below generates a list of odd numbers. 10 rows 1 column, starting at 1 and spaced 2 units apart.