Enable Flash Fill In Excel

Use AutoFill in Excel khổng lồ automatically fill a series of cells. This page contains many easy lớn follow AutoFill examples. The sky is the limit!

1. For example, enter the value 10 inlớn cell A1 and the value trăng tròn inlớn cell A2.

Bạn đang xem: Enable flash fill in excel

*


2. Select cell A1 và cell A2 và drag the fill handle down. The fill handle is the little green box at the lower right of a selected cell or selected range of cells.

*

Note: AutoFill automatically fills in the numbers based on the pattern of the first two numbers.

3. Enter Jan into cell A1.

*

4. Select cell A1 và drag the fill handle down. AutoFill automatically fills in the month names.

*

5. Enter Product 1 into cell A1.

*

6. Select cell A1 and drag the fill handle down. AutoFill automatically fills in the sản phẩm names.

*

7. Enter Friday inkhổng lồ cell A1.

*

8. Select cell A1 and drag the fill handle down. AutoFill automatically fills in the day names.

*

*

10. Select cell A1 và drag the fill handle down. AutoFill automatically fills in the days.

*

11. Instead of filling in days, use the AutoFill options lớn fill in weekdays (ignoring weekover days), months (see example below) or years.

Xem thêm: Pc Router Modem Cân Bằng Tải Cho Phòng Game Và Cafe Game Mobile Cần Nó

*

Note: also see the options lớn fill the formatting only & khổng lồ fill a series without formatting.


*

13. Select cell A1 và cell A2 và drag the fill handle down. AutoFill automatically fills in the dates based on the pattern of the first two dates.

*

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

*

15. Select cell A1 & drag the fill handle across. AutoFill automatically fills in the times.

*

16. When Excel doesn"t recognize a menu, simply create a custom các mục.

*

*

17. Use flash fill in Excel 2013 or later lớn automatically extract or khổng lồ automatically combine data.

*

*

If you have sầu Excel 365, you can also use the SEQUENCE function to lớn fill a series of cells. This function is pretty cool.

18. The SEQUENCE function below generates a two-dimensional array. Rows = 7, Columns = 4, Start = 0, Step = 5.

*

19. The SEQUENCE function below generates a menu of odd numbers. Rows = 10, Columns = 1, Start = 1, Step = 2.

*

Note: the SEQUENCE function, entered into cell A1, fills multiple cells. Wow! This behavior in Excel 365 is called spilling.