File-> Options->Advanced->Enable AutoComplete for cell values helps to activate the Formula AutoComplete function of Excel 2016
Step-by-step 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
- 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.