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

Cell reference used in formula of Numbers

Some times the cell reference appears as column and row and other times it appears as column heading and row heading. How do I control this?


Erik

Posted on Nov 17, 2022 9:04 PM

Reply
Question marked as Best reply

Posted on Nov 17, 2022 10:20 PM

Hi Erik,


This is controlled by a preference setting in Numbers Preferences > General:


Checked, the formulas will show the header names; unchecked, the formula will show the column letter and number row; for the example, LEN(B2)


Regards,

Barry

2 replies

Cell reference used in formula of Numbers

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