MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Change Multiple Cells From Showing Results Of Formulas, To Formulas?

Is there any way to select a whole column of cells. Say “Column A” has 200 cells going down to the bottom of the page. Each cell has a different result and different formulas in each cell to get those individual results. I want to select all 200 cells of “Column A”. And then display the formula in each cell rather than the result. Is there any way to do that? I know I can go to each individual cell one at a time. Select a cell, click on it. Then click fx and choose “Convert Formula To Text In Cell”. I am trying not to do 200 cells one at a time. But, I may have too. Can you help me with this?

I want to do this in order to print that Number file. It is easy for me to print that Numbers page with all the formulas I’m using. Make corrections and come up with new formulas making notes on that printed sheet.
—–
Javier Flores

Comments: 3 Responses to “How Do I Change Multiple Cells From Showing Results Of Formulas, To Formulas?”

    11 months ago

    You can use the FORMULATEXT function for this. So add column B. In B2 put the formula:
    =FORMULATEXT(A2)
    Then copy and paste that throughout column B. Now that column shows the formulas, and column A have the results.

    Javier
    11 months ago

    The FORMULATEXT function works great in Excel. But, I can not get it to work in Mac Numbers. I keep getting the orange error triangle in the cell that contains the FORMULATEXT function.

    11 months ago

    Javier: You can't use it on itself. If the formula is in A2, then put =FORMULATEXT(A2) into cell B2 to see the formula in cell B2.

Leave a New Comment Related to "How Do I Change Multiple Cells From Showing Results Of Formulas, To Formulas?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)