To accept the data either click the Check Mark or press Enter. Click Ok to apply the setting. Add to formula with Kutools for Excel.
As you type the data notice the data also appear in the Formula Bar.
In the Project Options dialog navigate to the Display page select the Entry bar option and click the OK button. Next click on Excel Options and move to the Advanced tab. To place a formula in a field. Click the fx icon to the left of the formula bar.