If you select the cell though the formula appears in the formula bar at the top of the Excel screen. Hold down the ALT F11 keys and it opens the Microsoft Visual Basic for Applications window. The left most is the Cell Name Box middle one Formula Bar Buttons and right one is the contents of the currently selected cell.
As you type the data notice the data also appear in the Formula Bar.
As you type the data notice the data also appear in the Formula Bar. The formula bar displays. This toolbar allows you to add frequently used commands. You can also hide the Formula Bar entirely by going to the View tab and uncheck the Formula Bar option.