It is usually there unless you have hidden it through the View options. The Cancel and Enter buttons on it only appear on the formula bar when you start to type into a cell.
It depends on your version of Excel and how you have it configured, but usually you will see the main menu tool bar (or ribbon) and the formula tool bar.
You can turn it on and off through the View menu.
The formula bar.
Just hide the Formula Bar.
In Microsoft Excel, text can be entered directly into a cell and in the formula bar. Whichever you enter it into, it will show in both as you enter it, so it cannot be in one and not the other. The formula bar shows the content of the active cell, so naturally as you type it will appear in both.
The Formula Bar.
To make the formula bar visible in Excel, go to the "View" tab on the ribbon and check the "Formula Bar" option in the "Show" group. Alternatively, you can right-click on the ribbon area and select "Customize the Ribbon," then ensure the Formula Bar is enabled in the settings. If you're using Excel for Mac, you can enable it by going to "Preferences" and then selecting "View," where you'll find the option to show the Formula Bar.
As Excel starts you will see the words Microsoft Excel in the title bar. After a few seconds the first worksheet will appear and then in the title bar a hyphen and Book1 will also appear beside Microsoft Excel. So what you will see is this: Microsoft Excel - Book1
In both the formula bar and the cell itself.
cell or formula bar!
The formula bar.
The Formula Bar.