Forum Question: How Do I Change a Formula In Numbers?

I’m trying to change a formula (formula bar shows up on bottom of spreadsheet). I can’t get into the formula to change; I must type in a new one.

Comments: 4 Responses to “How Do I Change a Formula In Numbers?”

    5/18/17 @ 3:07 pm

    You simply need to double-click on the cell in the table. The bar at the bottom is just a viewer. You need to edit it “in” the cell. You can also choose Edit, Edit Formula or the keyboard shortcut Control+= to start editing.

    5/18/17 @ 3:58 pm

    I thought I was doing that…..evidently not! Thank you for such a quick response!

    8/12/17 @ 1:10 am

    I have an existing formula with a $c expression in it that I want to use again referring to a new table. How can I get the set formula to refer to new table? It seems to be locked into its previous cell addresses

    8/12/17 @ 2:31 pm

    Roger: In the original formula, click on the C you see there and you should see “Preserve Column.” Try unchecking that to see if it works.

Comments Closed.