How do you activate the formula autocomplete function of excel 2016?

File-> Options->Advanced->Enable AutoComplete for cell values helps to activate the Formula AutoComplete function of Excel 2016

Explanation:

The AutoComplete option in Microsoft Excel will automatically load in data as you type. This piece is essential when inserting data into a worksheet that includes many copies. By AutoComplete on, when you rise to type, it will auto-fill the rest of the data from the circumstances encompassing it, to promote up data entry.

IN EXCEL 2019, 2016, 2013, AND 2010

answer6-9 screws;

answerpanning and scanning;