Entering And Editing Data In The Formula Bar. Scroll down to the Display section and select the Show Formula bar option. Power Query will display an Insert Step warning when you try to insert a new step.
Next click on Excel Options and move to the Advanced tab.
You can also use the Excel keyboard shortcut Control you will find this key in the top-left part of the keyboard under the Escape key. Open your spreadsheet in Excel 2010. Click the fx icon to the left of the formula bar. The Formula Bar has two parts.