Apple Intelligence is now available on iPhone, iPad, and Mac!

⏺ Join the discussion

⏺ Press release 

⏺ Learn more

⏺ Watch the video

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

User profile for user: BofB
BofB Author
User level: Level 1
8 points

When editing Apple Numbers shows column and row head and not formula. I need to show formula

When editing Apple Numbers (double click) the cell shows row and column head name and not formula. I need to show formula to edit it. Example: A6+B2


MacBook Pro 13", macOS 10.12

Posted on Mar 2, 2020 2:46 PM

Reply
Question marked as Top-ranking reply
User profile for user: Yellowbox
Yellowbox
User level: Level 7
21,035 points

Posted on Mar 2, 2020 3:32 PM

Hi BofB,


Menu > Numbers > Preferences > General > Cell References > untick "Use header names as labels"



Regards,

Ian.

View in context
4 replies

When editing Apple Numbers shows column and row head and not formula. I need to show formula

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