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

Question:

Question: Replace formulae with their calculated values.

I am operating a fairly ordinary spreadsheet that brings values from various sources into a single sheet that represents a summary of all income and expenses in a year. I want to extract the budget with its values, but not its formulae as I only want to retain it as a single sheet. If I delete sheets, I lose data. I can do it in MS Excel: can it be done in Numbers 4.3.1 without doing it manually?

MacBook Pro, Mac OS X (10.7.3), iWork '09

Posted on

Reply
Question marked as Solved
Answer:
Answer:

The equivalent to Excel's Paste Special > Values is Edit > Paste Formula Results.


Select the cells where you want to "remove" formulas, command-c to copy, and Edit > Paste Formula Results.


SG

Posted on

User profile for user: g7mcd

Question: Replace formulae with their calculated values.