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
Question marked as
Top-ranking reply
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