Show Formulas in Excel on iPad: View Cell Formulas

In Excel on iPad, tap a cell to see its formula in the formula bar. To display formulas inside every worksheet cell, look for a Show Formulas command under View; if your app does not offer it, open the workbook in Excel for the web or desktop and turn on Show Formulas there. The iPad app’s available commands can vary by version, so the steps below cover both ways to check a formula and reveal a whole sheet.

What You’ll Need

An iPad with the Microsoft Excel app installed and the workbook open. Update Excel from the App Store if the ribbon or commands described here are missing.
Permission to view or edit the workbook. You can inspect formulas in a workbook you can open, but a protected sheet or file may limit changes.
If you need to show every formula and the iPad app has no Show Formulas command, access to Excel for the web or Excel on a computer will help. The workbook should be saved to a location you can open from that version.

Step-by-Step

Open the workbook and go to the right worksheet. In Excel for iPad, open the file from your recent workbooks or browse to its saved location. If there are multiple sheet tabs along the bottom, tap the sheet that contains the calculation you want to inspect. Formula display applies to the active worksheet, so make sure you are not looking at a similarly named tab.
Select a cell that contains a formula. Tap the cell once. Excel normally shows the cell’s calculated result in the grid, while the formula bar displays the formula used to produce it. For example, a cell might show a total in the grid while its formula bar shows how that total is calculated. A cell containing a typed number or text will not have a formula to display.
Find and read the formula bar. Look above the worksheet grid for the formula bar, often near the ribbon. It may show an fx symbol or an editing area. Tap inside the bar if you need to read more of a long formula; on some layouts the bar expands or opens the on-screen keyboard. Read the expression without typing. If you do not intend to edit it, tap a blank area or use the iPad’s dismiss-keyboard control to leave the editing area safely.
Check whether the iPad app has a sheet-wide display option. Tap the View tab on the ribbon and look for a command called Show Formulas. If it is present, tap it once. Excel should replace calculated results with formulas in formula cells on the active sheet. Depending on the app version, the command may be grouped with other viewing options or may not be available at all. Do not assume that a formula bar showing one selected formula means all formulas are now visible in the grid.
If you cannot see the formula bar, check its visibility. While the workbook is open, inspect the View tab for a Formula Bar option or similar display control. If the option is present and the bar is hidden, turn it on, then select the cell again. Ribbon labels and placements can shift as Microsoft updates Excel, so look for the control by name rather than expecting it to sit in one exact position on every iPad.
Use Excel for the web when you need every formula visible. If the iPad app does not include Show Formulas, save or sync the workbook to OneDrive or another supported location, then open it in Excel for the web using a browser. If the browser keeps opening the Excel app, use the browser’s desktop-site option where available. In the workbook, open the Formulas tab and choose Show Formulas. If the desktop-style ribbon is not available in the browser, use Excel on a computer instead.
Use Excel on a computer as the dependable alternative. In Excel for Microsoft 365 on Windows, open the worksheet and choose Formulas > Formula Auditing > Show Formulas. In Excel for the web, choose Formulas > Show Formulas. On Mac, look for Show Formulas on the Formulas tab; ribbon organization can differ from Windows. These commands display formulas throughout the active worksheet, not just in the selected cell.
Return the sheet to its normal view when finished. Tap Show Formulas again in the version where you enabled it. The same command switches between formula display and calculated results. If you used the web or desktop version, save the workbook and reopen or refresh it on the iPad. A formula-view setting may not carry over in the way you expect between apps, so check the iPad view after returning.

When Show Formulas is active, Excel displays formulas only in cells that contain formulas. Cells containing labels, dates entered as fixed values, and manually typed numbers remain unchanged. The command changes how the sheet is displayed; it does not replace formulas with text or alter their calculations. You can still select a cell to inspect its formula bar, although the grid itself may be harder to scan until you turn the setting off.

Common Mistakes

Expecting a formula to appear in every selected cell: A cell may contain a fixed value rather than a calculation. Tap a different cell that you know is calculated, or inspect the formula bar for an equals sign at the start of the expression. If the cell has no formula, Excel has nothing to reveal for it.
Confusing the formula bar with sheet-wide formula display: The formula bar normally shows the contents of the selected cell only. It does not mean the whole worksheet has switched to formula view. To see many formulas at once, use Show Formulas if available, or open the workbook in Excel for the web or desktop.
Editing a formula by accident: Tapping the formula bar can put the cell into edit mode and bring up the keyboard. A stray character or deleted symbol can change the calculation. If you have not meant to edit, dismiss the keyboard without entering changes. If you did alter something, use Undo promptly or close without saving if you are certain you want to discard all unsaved changes.
Thinking the formula view changed the workbook’s results: Show Formulas is a viewing switch, not a conversion or recalculation command. A cell that previously displayed a result may now display its expression, but the formula remains in the cell. Toggle the command off to return to the regular result view.
Assuming every Excel version has identical buttons: The iPad app, browser version, Windows app, and Mac app do not always expose the same controls in the same places. If a command is missing, confirm which version you are using and choose the available alternative instead of following a desktop ribbon path on the iPad.

Tips

Use single-cell inspection for a quick check, such as confirming which cells a total refers to. It is usually the fastest option when you only need to verify one or two calculations. Tap the cell, read the formula bar, and avoid tapping into the formula itself unless you intend to edit. For a large worksheet audit, switch to Show Formulas on the web or desktop so you can scan many expressions together.

Formula display often makes columns look too narrow because formulas take up more space than their results. You may see clipped text or hash marks in a narrow cell. That does not necessarily mean the formula is broken. Widen the relevant columns in the version you are using, or inspect individual cells in the formula bar. When finished, switch back to results so the worksheet is easier to read.

Before sharing a workbook, check whether you want recipients to see results or formulas. Showing formulas is not the same as hiding sensitive information: people with access to the workbook may still be able to inspect formula contents. If a workbook contains confidential calculations or data, use appropriate file permissions and review what is stored in the cells and references rather than relying on the display mode.

For a clear audit, check both the formula and its inputs. A formula can be syntactically valid but still refer to the wrong row, range, or sheet. On iPad, select the formula cell and read the formula bar; if the expression is long or difficult to follow, use the larger screen and auditing features in desktop Excel. Avoid changing values just to test a calculation in the original file—make a copy first if you plan to experiment.

Troubleshooting

The formula bar is missing: Tap the View tab and look for a Formula Bar display option. If it is turned off, enable it and select the cell again. If you cannot find the option, update Excel and check the ribbon tabs carefully. You can also rotate the iPad to landscape or adjust the ribbon display; limited screen space can hide or rearrange controls.

Show Formulas is not listed on the iPad: Your app version may not provide a sheet-wide formula display command. You can still tap individual cells to inspect their formulas. To reveal formulas throughout a sheet, open the file in Excel for the web and use Formulas > Show Formulas, or open it in desktop Excel and use the corresponding command on the Formulas tab.

The formula bar shows a value, not a formula: Confirm that you selected the intended cell. If the formula bar contains only a number or text, that cell may have a fixed value, or a formula may previously have been replaced by its result. Check another known calculation. Excel cannot reconstruct a formula that has been overwritten unless you can restore an earlier version or undo the change.

The formula appears cut off: Tap the formula bar and see whether the full expression can be expanded or scrolled. Long expressions may not fit in the visible area, particularly in portrait orientation. Rotate the iPad, expand the bar if the control is available, or open the workbook on a larger screen to inspect the full expression more comfortably.

The workbook looks different after switching apps: Confirm that the file has finished syncing and that you opened the same workbook, not a downloaded copy or an older version. Save changes in the web or desktop app, then reopen the file on the iPad. If the formula display does not match, toggle the available display command in that version; the formula itself and the display setting are separate things.

Frequently Asked Questions

Can I show all formulas in Excel on an iPad?

Only if your Excel for iPad version provides a Show Formulas command, typically under View. If you do not see it, the dependable options are Excel for the web or desktop Excel. Selecting a cell on iPad still lets you inspect that cell’s formula in the formula bar.

How do I see the formula for just one cell?

Tap the cell once and read the formula bar above the worksheet. If the expression is long, tap the bar to expand or scroll through it. Avoid typing while the cell is in edit mode unless you want to change the formula.

Why does the cell show a number instead of its formula?

Excel normally displays a formula’s calculated result in the grid. The formula appears in the formula bar when you select the cell, or in the grid when Show Formulas is enabled in a version that supports that view. A manually entered number has no formula to display.

Does showing formulas change or calculate anything?

No. Show Formulas changes the worksheet’s display, not the stored calculation. It does not turn formulas into text or replace results. Switch the command off to display the calculated results again.

Can I use a keyboard shortcut on the iPad?

The Windows shortcut for toggling formula display is Ctrl+grave accent, but it requires a compatible keyboard and desktop Excel; it is not a dependable touch command in the iPad app. On iPad, use the ribbon if the command exists, or use Excel for the web or desktop for sheet-wide display.

Will other people see formulas if I turn this on?

The command is a display setting, not a security feature. It does not remove formulas or protect their contents. Anyone with suitable access to the workbook may be able to inspect formulas, so use file permissions and workbook protection where appropriate.

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.