How to Show Formula Bar in Excel (Easiest Way in 2025)

In this article, we will show you how to add the formula bar in Excel. Simply follow the steps below.

Show Formula Bar in Excel

To add the formula bar in Excel, simply follow the process below.

1. Find the View Tab

Look for the ‘View’ tab in the ribbon at the top of the Excel screen. Click on this tab to access various display options available for your workspace.

2. Locate the Formula Bar Option

In the ‘View’ tab, search for the ‘Formula Bar’ checkbox. It’s located among several other options that control what elements are visible in your Excel interface.

3. Display the Formula Bar

Click the checkbox next to ‘Formula Bar’ to make it visible. If it’s already checked, this means the formula bar is currently displayed. Unchecking this box will hide the formula bar. Once enabled, the formula bar will appear directly above your spreadsheet, making it easier to view and edit any formulas in your cells.

We hope you now have a better understanding of how to show the formula bar in Excel. If you enjoyed this article, you might also like our article on how to show a toolbar in Excel or our article on how to create a progress bar in Excel.