How to Show Formulas in Excel for Mac

Formulas & functions · Updated November 18, 2026

To show formulas in Excel for Mac, open the worksheet and choose Formulas > Show Formulas. You can also press Control+grave accent (the key marked `) to switch formula display on or off. Excel then shows formula text in cells instead of calculated results, which is useful for checking, reviewing, and explaining a worksheet.

What You’ll Need

  • Excel for Mac and a workbook containing formulas. The instructions apply to recent Microsoft 365 versions; ribbon labels or placement can differ slightly in older releases.
  • Access to the worksheet you want to inspect. Formula display is a worksheet view setting, so you may need to turn it on separately on other sheets.
  • A keyboard with a grave accent key if you want to use the shortcut. The key is often near the upper-left corner, but its position depends on your keyboard layout.

Step-by-Step

  1. Open the workbook and choose the right sheet. Open the Excel file, then select the worksheet whose formulas you want to inspect by clicking its tab at the bottom. If the workbook is protected, you may need permission to change its settings or edit its cells. Showing formulas normally changes the display rather than the formula calculations, so it is a safe way to review a sheet without replacing its results.
  2. Open the Formulas tab. In the ribbon at the top of the Excel window, click Formulas. If the ribbon is collapsed, expand it or select the tab to reveal its commands. Look for the Formula Auditing area. Depending on the Excel for Mac version and window width, the controls may be grouped or arranged differently, but the command is named Show Formulas.
  3. Turn on formula display. Click Show Formulas. Cells containing formulas should now display the formula itself, such as =SUM(B2:B8), rather than its calculated total. The formula remains in the cell; Excel has not converted it to text or changed the calculation. Other cells that contain typed values, labels, or dates continue to show those entries.
  4. Use the keyboard shortcut if you prefer. Press Control+grave accent to toggle the display. This is Control, not Command. On many keyboards the grave accent is the unshifted character on the key that also has the tilde. If the shortcut types a character, does nothing, or is awkward on your keyboard layout, use the ribbon command instead. The shortcut changes the same setting as Show Formulas.
  5. Make the formulas readable. Formula text can be longer than the results it replaces, so it may not fit in the existing column widths. Drag a column boundary in the column headings to widen it, or double-click a boundary to autofit that column to its contents. You can also select several columns and autofit them together. Widening columns changes the layout, not the underlying formulas or values.
  6. Review the displayed expressions. Scan the cells to check references, operators, and function names. For a closer look at one cell, select it and read the formula bar above the grid. The formula bar is useful when a formula is too long to read in the cell, even after widening the column. You can use the arrow keys to move through neighboring cells while checking formulas.
  7. Turn formula display off when finished. Click Formulas > Show Formulas again, or press Control+grave accent again. Excel returns the worksheet to its usual view, showing calculated results where formulas are present. If you want to inspect another sheet, select its tab and check whether formula display is enabled there; switch it on or off as needed.

Common Mistakes

  • Confusing formula display with the formula bar: Show Formulas changes the view across a worksheet. The formula bar, by contrast, shows the contents of the selected cell while other cells continue to show their results. To inspect one formula, selecting its cell may be all you need.
  • Using Command instead of Control: The Mac shortcut for toggling formula display uses Control with the grave accent key. Command is used for many other Mac shortcuts, but it is not the key to substitute here. If a keyboard layout makes the shortcut uncertain, click the ribbon command.
  • Thinking the formulas have been overwritten: Seeing expressions instead of totals does not mean Excel replaced the formulas. Turn Show Formulas off to see the calculated results again. Avoid typing into cells while reviewing, since typing would actually replace their contents.
  • Expecting every cell to show a formula: Only cells that contain formulas can display them. Cells with manually entered values or text still show those entries. A blank cell remains blank, unless it has content or formatting that makes it appear otherwise.
  • Forgetting the longer text needs room: A narrow column may make displayed formulas look cut off or difficult to distinguish. Widen the column or use the formula bar rather than assuming that a formula is missing.

Tips

  • Use formula display for an audit, then restore the normal view. It is handy when checking a copied formula down a column, reviewing a colleague’s workbook, or documenting how a result is calculated. Toggle it off before presenting or printing the sheet if readers need to see the results.
  • Inspect references while moving down a column. Select the first formula, then move through cells with the arrow keys. Compare the cell references in neighboring formulas. This can help reveal an accidental fixed reference, a skipped row, or a formula that was not filled down consistently.
  • Do not mistake displayed formula text for editable documentation. The expression is still the cell’s working formula. If you need to explain the calculation, add a cell comment or a separate note rather than typing over the formula cell.
  • Keep a normal-view copy for sharing when appropriate. Formula display is a view setting, not a different calculation, but it can confuse someone opening the workbook. Turn it off before sharing if the recipient expects to see totals. If the workbook is intended for formula review, tell them that the worksheet is showing expressions on purpose.
  • Use the formula bar for very long expressions. Widening a column can make a worksheet unwieldy, especially when formulas contain many nested functions. Select the cell and read the formula bar to inspect the expression without changing the width of the whole table.
  • Remember that each sheet can need its own setting. After switching tabs, check the view rather than assuming the shortcut or ribbon action affected every worksheet. If you are auditing a multi-sheet workbook, visit each relevant sheet and enable formula display as needed.

Troubleshooting

  • The Show Formulas button is hard to find. Confirm that the Formulas tab is selected, then look in the Formula Auditing group. If the window is narrow, some ribbon commands may be compressed or moved into a menu. Maximize the Excel window or use the ribbon search field, if available in your version, to find Show Formulas.
  • The keyboard shortcut does nothing. Check that you are pressing Control rather than Command and that you are using the grave accent key, not an apostrophe. Key placement and combinations vary by keyboard layout. Try the Formulas tab command to confirm that the feature works; the ribbon method does not depend on locating the special key.
  • Only one cell appears to contain a formula. Other cells may contain fixed values, be blank, or be on another worksheet. Select a cell and look at the formula bar to see whether it contains a formula. You can also check the formula cells you expect one by one; Show Formulas does not create formulas in cells that did not have them.
  • Formula text is cut off or hard to read. Widen the relevant columns by dragging their borders or autofitting them. For especially long formulas, select the cell and inspect the formula bar. If the worksheet becomes too wide, restore the original widths after you finish reviewing.
  • A cell shows an expression even after formula display is off. The entry may be text rather than an active formula. A formula entered while the cell was formatted as Text, or preceded by an apostrophe, can be treated as text and displayed literally. Select the cell and inspect its contents in the formula bar. If it should calculate, change the cell format to General, then re-enter the formula so Excel evaluates it. Do this carefully, because changing the format alone may not convert an existing text entry.
  • The displayed result seems incorrect. Show Formulas reveals the expression, not whether the logic is correct. Check the references and operators, then return to normal view to see the calculated result. If the result has not updated after an edit, check Excel’s calculation settings and recalculate the workbook; formula display itself does not change calculation settings.

Frequently Asked Questions

Does Show Formulas change or delete my formulas?
No. It changes how formula cells are displayed on the worksheet. The expressions remain in their cells, and turning the setting off returns the calculated results to view.

What is the shortcut to show formulas in Excel for Mac?
Press Control+grave accent to toggle the setting. The grave accent key is often near the top-left of the keyboard, but layouts differ. If the shortcut does not work on your keyboard, use Formulas > Show Formulas.

Can I show formulas in just one cell?
Show Formulas is a worksheet-wide display setting, not a per-cell switch. To inspect one formula without changing the sheet view, select that cell and read the formula bar.

Why do I see formulas on one sheet but results on another?
Formula display may be enabled on one worksheet and disabled on another. Select each sheet and use Show Formulas to set the view you want there.

Can I print a worksheet with formulas showing?
Yes. If formula display is on when you print, the worksheet may print the expressions rather than their results. Check Print Preview first, and turn Show Formulas off if you want the printed sheet to show calculated values.

How can I show formulas without making the columns wider?
You can leave the columns as they are and select individual cells to inspect their contents in the formula bar. For a full-sheet review, some formulas may be clipped in the grid until you widen columns, so the formula bar is a practical alternative for long expressions.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.