F2 does not turn on a worksheet-wide formula display in Excel: it puts the selected cell into edit mode. To show formulas in every cell, press Ctrl+` on Windows, or use Formulas > Show Formulas; to inspect one cell, select it and look at the formula bar or press F2.
What F2 Does in Excel
In Excel for Microsoft 365 on Windows, F2 edits the active cell. If that cell contains a formula, F2 lets you see and edit the formula in the cell, rather than simply displaying its calculated result. It does not change the display setting for other cells, and it is not a command to reveal every formula on the sheet.
For example, if B2:B6 contain the numbers 2, 3, 4, 5, and 6, and B7 contains =SUM(B2:B6), Excel displays 20 in B7 under the usual settings. Select B7 and press F2 to inspect the formula in that cell. Press Enter to accept any edit, or Esc to leave edit mode without keeping changes. If you only want to inspect the formula, avoid typing while editing.
Excel may show the insertion point within the cell, or let you edit the formula in the formula bar, depending on the setting for editing directly in cells. Either way, F2 acts on the selected cell; it does not toggle formula view for the worksheet.
How to Show Formulas in Every Cell
To replace calculated results with their formulas across the current worksheet, use either of these methods:
- Press Ctrl+` on a Windows keyboard. The grave accent is commonly on the key to the left of 1, though its position can vary by keyboard layout.
- On the ribbon, select Formulas > Show Formulas. Select the command again to return to calculated results.
This setting is a display toggle, not a change to the calculations or cell contents. A formula such as =SUM(B2:B6) remains the formula in the cell; Excel merely displays it instead of its answer. The formula-view setting applies to the active worksheet, so another sheet in the same workbook may still show results normally. Column widths may need adjusting because formula text often takes more space than a number.
If you pressed F2 expecting to show every formula, nothing is necessarily broken: use the toggle instead. If the shortcut has no effect, use the ribbon command to check the setting and avoid uncertainty about the grave-accent key on your keyboard.
Check the Formula Bar for One Cell
If the goal is to read one formula without switching the whole sheet into formula view, select the cell and inspect the formula bar above the worksheet grid. A formula cell normally shows its formula there, even while the grid displays the calculated result. If the formula bar is not visible, turn it on from View > Show > Formula Bar in Excel for Windows.
F2 is useful when you need to inspect references or make a small edit, but it puts the cell into edit mode. For a quick, read-only check, the formula bar is often safer. You can also select the cell and press Esc if you entered edit mode accidentally; this cancels edits made during that edit session.
Why F2 or the Formula Shortcut May Seem Not to Work
First identify what is actually visible and what you expect to happen. These common situations can look similar but have different causes:
- The cell shows a number, and you want to see its formula: select the cell and check the formula bar. F2 opens the cell for editing; the worksheet-wide option is Show Formulas.
- F2 changes screen brightness or another hardware setting: many laptops assign media actions to function keys. Try Fn+F2, or change the function-key behavior in the computer’s keyboard settings. The exact setting depends on the device.
- The shortcut does not toggle formula view: the grave accent may be in a different place on your keyboard, or the keyboard layout may use a different key combination. Use Formulas > Show Formulas instead.
- F2 cannot edit the cell: the worksheet may be protected, or the cell may be locked. Check Review > Unprotect Sheet if you are authorized to change the sheet. If a password is required, ask the workbook owner; do not assume there is a way to reveal protected content without permission.
- The cell displays formula characters as text: it may have Text formatting, a leading apostrophe, or a leading space. That is different from formula view and is covered below.
Also distinguish display from calculation. If a formula is visible but its answer seems outdated, the calculation mode may be set to Manual. Check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook. Recalculation affects results; it does not control whether formulas are displayed.
When a Formula Appears as Text
If a cell shows something like =SUM(B2:B6) as literal text even though Show Formulas is off, Excel may not have recognized the entry as a formula. One common cause is that the cell was formatted as Text before the formula was entered. A leading apostrophe or space before the equals sign can also make the entry behave like text.
To correct an individual entry, select the cell, choose Home > Number Format and set the format to General. Then press F2 and Enter so Excel reinterprets the existing entry. If there is an apostrophe or an accidental space before the equals sign, remove it while editing. Check the result before repeating the change across many cells, since the cells may contain text you intended to keep.
There is an important difference between this problem and Show Formulas mode. In Show Formulas mode, formula cells display their formulas because a worksheet display option is active; turning the option off restores the results. A text entry remains text until it is corrected and evaluated as a formula.
Hidden Formulas and Protected Worksheets
A workbook owner can mark a formula as hidden and then protect the worksheet. In that case, Excel can suppress the formula in the formula bar while the cell continues to display its result. Pressing F2 or turning on Show Formulas may not reveal a formula that has been intentionally hidden under worksheet protection.
If you maintain the workbook, check the protection settings and the cell’s protection properties after unprotecting the sheet. The Hidden property takes effect when the worksheet is protected. If you do not own the workbook, ask its author for access or an explanation; a missing formula in the formula bar may be an intentional protection choice rather than a shortcut failure.
Windows, Mac, and Excel for the Web
The main distinction is the keyboard, not the purpose of F2. On Windows, F2 edits the selected cell, while Ctrl+` toggles formula display. On a laptop, you may need the Fn key for F2. For the formula display toggle on a Mac, try Control+`; the grave-accent key position depends on the keyboard layout. If that shortcut is unavailable or behaves differently on your setup, use the Show Formulas command on the Formulas tab.
On a Mac, function keys may be assigned to hardware controls, so F2 may require Fn+F2, depending on macOS keyboard settings and the keyboard. In Excel for the web, browser and device shortcuts can affect function-key behavior. Use the ribbon’s formula-display command when a keyboard shortcut is intercepted or unclear. The formula bar is another direct way to inspect a selected cell without relying on F2.
Return to Normal Results and Check the Sheet
If formulas are suddenly visible everywhere, the most likely explanation is that Show Formulas was toggled on. Press Ctrl+` again on Windows, or select Formulas > Show Formulas to switch back. If only one cell shows formula text, check whether it is text-formatted instead of assuming the worksheet-wide view is active.
After restoring the normal display, verify a few cells by selecting them and reading the formula bar. This helps confirm that the formulas are still present and that the cells were not accidentally overwritten while editing. If the numbers do not update, review calculation settings separately; display mode and recalculation are independent issues.
Frequently Asked Questions
Does F2 show formulas in all Excel cells?
No. F2 edits the active cell. Use Ctrl+` on Windows or Formulas > Show Formulas to display formulas throughout the current worksheet.
How do I see a formula without editing it?
Select the cell and read the formula bar. If it is not visible, enable it under View > Show > Formula Bar in Excel for Windows.
Why does F2 change my laptop’s brightness?
Your laptop may assign its function keys to hardware actions by default. Try Fn+F2, or review the device’s function-key settings. The exact behavior depends on the computer.
Why is a formula displayed literally in the cell?
The cell may be formatted as Text, or the entry may start with an apostrophe or space. Set the cell to General, remove unintended characters, then re-enter the formula with F2 and Enter.
Can Show Formulas reveal a formula hidden by worksheet protection?
Not necessarily. A formula marked Hidden on a protected worksheet can be suppressed in the formula bar. Ask the workbook owner or use the appropriate authorized sheet-protection access.
Related
- Excel Custom Number Format for Day of Week: ddd and dddd
- Excel Custom Number Format for Negative Numbers in Brackets
- Excel Custom Number Format Cheat Sheet and Examples
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- VLOOKUP Not Working With Leading Zeros? Here’s WhyVLOOKUP often fails with leading zeros because Excel may store one lookup key as text, such as “00123,”…
- Excel SUMIFS Not Working? Causes and FixesYes—Excel SUMIFS can return zero, the wrong total, or an error when its ranges, criteria, or data types…
- IFERROR in Excel Not Working? Causes and Practical FixesIf IFERROR is not working in Excel, first check that the cell contains a formula that actually returns…
- Excel MATCH Greater Than Not Working? Fixes That WorkExcel’s MATCH function does not treat a greater-than sign in its lookup value as a condition. For the…
- LEFT Excel Formula Not Working? Fix ItIf your LEFT formula is not working, check that the formula starts with an equals sign, refers to…
- Excel COUNTIF Not Counting Properly? Fix the CauseIf Excel COUNTIF is not counting properly, check the criterion, the cells’ actual contents, and the range first:…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.