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.

numbers changes my formulas to titles of cells - way to prevent it?

Hi,

I am working across multiple sheets. From my overview sheet I want to import some number from several countries each on a different sheet and compare them.

When I select something like 'at-rns':$K$30 numbers automatically replaces it with the title of the field which is something like sumAT. I don't want this, I want to be able to copy the actual field reference in another field and just need to change the sheet-name.

Is there any way to prevent numbers from doing this?

Actually I would like to disable everything which was added after iWork 09, as the Numbers where meant for table calculation, but keeping cell references in the referencing cells untouched would help really a lot.


Thanks!

MacBook Pro 17″, macOS 10.13

Posted on Mar 4, 2021 4:15 PM

Reply
Question marked as Top-ranking reply

Posted on Mar 5, 2021 2:08 AM

Is there any way to prevent numbers from doing this?


Numbers Preferences > General

Uncheck the indicated checkbox:


Regards,

Barry

4 replies

numbers changes my formulas to titles of cells - way to prevent it?

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