You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Show formulas in Numbers cells?

Is there any way to show all the formulas in Numbers cells? Sometimes I need to show how I derived results for clients and I'd like to have the formulas for each cell all appear on one sheet that I can PDF to send them.

iMac Line (2012 and Later)

Posted on Jul 10, 2020 11:17 AM

Reply
5 replies

Jul 10, 2020 5:08 PM in response to whowland

Only if you do them one at a time. But doing so converts the formula to text in the cell, it is no longer a formula, it becomes text in the cell (just like it says). That will have a major effect on any cells that depend on that one as an input.


When editing the formula, click on the little down arrow next to the fx and choose "Convert Formula to Text in Cell". To convert the text back to a formula, type an = in front of it.


Show formulas in Numbers cells?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.