You all know the Formula Bar resides at the top of your Excel window, immediately below the Ribbon area or the Formatting toolbar depending on which version of Excel you own the license to.
If the Formula Bar serves as a distraction to you, you have the option of turning it off.
Follow the steps below to learn how:
- Click the File tab of your Ribbon to display the Excel Options dialog box.
- On the Left-hand side, click Advanced.
- Scroll down until you see Display options.
- Click on the Show Formula Bar checkbox. If it is already selected, then the Formula Bar is displayed. Deselect it and it will not be displayed.
- Click Ok.