OmniDocShow Formulas and the Formula Bar in Excel
Learn how to show formulas in an Excel spreadsheet, hide or restore the formula bar, and fix formulas that display as text or stop updating.
You open a spreadsheet and every cell shows a number, but you need to see the formulas behind them. Or the opposite happens: formulas appear as plain text, and nothing calculates. Other times the bar across the top of the window, where you read and edit formulas, has disappeared and you can't find it. These are all display settings in Excel, and they are easy to change once you know where they live.
This guide is for anyone who needs to show formulas in an Excel spreadsheet, hide or restore the formula bar, or figure out why formulas aren't behaving as expected. You don't need advanced Excel skills. You need to know which setting controls what you see, and how to check it.
Below, you'll find a quick answer, a checklist to run before you change anything, step-by-step instructions, and a way to confirm the sheet looks the way you want. The short answer comes first.
How do you show formulas in Excel and turn the formula bar on or off? The short answer
Use the formula display option in the Formulas section of the ribbon, or press Ctrl+` (the grave accent key, usually found under Esc) to show formulas instead of results. Turn the formula bar on or off with its checkbox on the View tab. Both are view settings: they change what you see on screen, not the formulas in your file.
| Your situation | What to do | Why |
|---|---|---|
| You want to see every formula on the sheet | Turn on Show Formulas from the Formulas tab, or press Ctrl+` | Cells display the formula text instead of the calculated result |
| You want more room and no formula bar | Clear the formula bar checkbox on the View tab | This hides the bar above the grid. Formulas still calculate and still appear in cells |
| A formula shows as text and doesn't calculate | Change the cell format to General, then press F2 and Enter | Cells formatted as Text store what you type as plain text |
| Results stopped updating after you edited data | Set calculation to Automatic in the Formulas tab | Manual calculation waits until you tell Excel to recalculate |
Before you start
A few checks will save you time and prevent confusion about what changed.
- Save a copy of the workbook. View changes are harmless, but if you also edit cell formats while troubleshooting, a copy lets you go back to the original.
- Check whether you're looking at the right sheet. Show Formulas can differ between sheets, so a formula that appears correct on one tab may look different on another. Click through each tab you're checking.
- Confirm that the cell contains a formula. Click the cell and look at the formula bar, if it's visible. A formula starts with an equals sign. If the cell holds a typed number or a word, there's no formula to show.
- Know the difference between view settings and protection. Hiding the formula bar and showing formulas only changes the display. If someone else needs to be prevented from seeing or editing formulas, that requires sheet or cell protection, which is a separate feature.
- Note the calculation mode first. If you suspect a calculation problem, check the calculation options before you edit any formulas. Changing a formula won't help if the workbook isn't recalculating.
Showing formulas in Excel, step by step
- Save a copy of the file. This keeps your original workbook intact while you adjust display settings.
- Select the sheet you want to inspect. Settings can vary between sheets, so start with the one where you noticed the problem.
- Turn on Show Formulas. Open the Formulas tab and enable the formula display option, or press Ctrl+` (the grave accent key). Every cell with a formula now shows the formula text.
- Turn Show Formulas off when you're done. Use the same option or shortcut again to return to showing calculated results. Leaving it on can make a sheet harder to read for anyone who opens it later.
- Hide or restore the formula bar. On the View tab, clear the formula bar checkbox to hide the bar, or select it to bring the bar back. Hiding it gives you more room in the window but removes the place where you read and edit long formulas.
- Fix formulas that show as text. Select the affected cells, change the number format from Text to General, then select each cell, press F2, and press Enter. This re-enters the formula so Excel recognizes it as a formula.
- Set calculation to Automatic if results don't update. In the Formulas tab, open the calculation options and choose Automatic. If the workbook was set to manual, results will refresh as you edit.
- Save and close the file. Before sharing it, make sure Show Formulas is off, unless the recipient needs to see formulas.
Check the result
After you change the settings, confirm that the sheet looks the way you intended. Use this table to catch a common problems.
| Check | How to see it | If it's wrong |
|---|---|---|
| Show Formulas is set correctly | Cells show formula text (when on) or results (when off) | Press Ctrl+` again, or use the Formulas tab option, to toggle it |
| Formula bar is visible or hidden as you want | The bar sits above the column letters or is gone | Select or clear the formula bar checkbox on the View tab |
| Formula is recognized | Results appear, not the formula text | Change the cell format to General, then press F2 and Enter |
| Results update when you edit data | Change an input value and watch the result | Set calculation to Automatic and recheck the formula |
| No accidental changes | Compare against your saved copy | Restore the copy and repeat the steps one at a time |
❓ FAQ
1. Can I hide the formula bar without hiding formulas?
Yes. The formula bar checkbox on the View tab controls only the bar above the grid. Formulas in cells keep displaying their results, and the calculations keep running. Showing formulas is a separate setting.
2. Does hiding the formula bar protect my formulas?
No. Hiding the bar only changes what's visible on screen. Anyone can turn it back on. To stop others from editing formulas, use sheet protection and lock the cells that contain formulas.
3. What's the difference between showing formulas and locking formulas?
Showing formulas changes the display so formula text appears instead of results. Locking formulas controls who can change them, using protection settings. You can show formulas without locking anything, and you can lock cells without showing their formulas.
4. Will turning on Show Formulas change my file?
It changes what you see, not the formulas themselves. Excel may save the view state with the workbook, though, so the file can open with formulas showing. Turn Show Formulas off before you share the file, unless the recipient needs to see formulas.
📝 Summary
Showing formulas in an Excel spreadsheet and managing the formula bar are both view settings, so you can change them without affecting your calculations. If a formula appears as text or results stop updating, check the cell format and calculation mode before you assume the formula is wrong. Save a copy first, and turn Show Formulas off before sharing the file.
