Shortcut to accept suggested formula in Excel

When starting to type a formula in Excel, you get the suggested formulas automatically. You use the arrows to go down, press Enter and…. #NAME? appears.

How to select the suggested formula? Use TAB, instead of Enter.

« Return last day of the month

Show weekday or month as text instead of number »