File-> Options->Advanced->Enable AutoComplete for cell values helps to activate the Formula AutoComplete function of Excel 2016
<u>Explanation:</u>
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
Travel to the File -> Options menu.
In the Excel Options windowpane, choose Advanced on the left.
Below the Editing Options part, toggle Enable AutoComplete for cell values on or off depending on whether you require to turn this comment on or disable it.
Click or tap OK to save the changes and continue using Excel.
