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 Mar 5, 2018 6:18 AM

Reply
2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Replace formulae with their calculated values.

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