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.

Level 1

4 points

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

Top-ranking reply

Level 9

59,951 points

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

View in context

Similar questions