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

Similar questions

Stop formula suggestions Hi This is probably very basic and easily fixable, but it is driving me mad. I am double-clicking into cells to edit and then copy their content, but after a short while numbers is now suggesting formulas with a little window that pops up and each subsequent double-click in the cell just adds that cell reference number to the formula prompt, rather than letting me edit and copy the text in the cell. I don't know what the feature is called. How can I turn this off? Thanks
882 5
Numbers. How to get the value in a cell I keep my home accounts using a numbers spreadsheet - the last column is a formula showing the running total. However, when I sort the information by date the formula does not stay pointing at the cell above. It seems to keep the cell reference where it came from and no longer references the pertinent values. Is there a way to keep the formulas intact when I sort by date?
542 1
Numbers How to fix formula showing Table for one column but not the other when selected same way? I need help with Numbers formula not showing correctly for one of two columns table; Table is shown in same formula for a column but not it’s neighbouring column. why isn’t Table shown?
918 1

2 replies

Barry

Level 9

60,017 points

Nov 17, 2022 10:20 PM in response to erikjoch

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

erikjoch Author

Level 1

4 points

Nov 19, 2022 5:45 AM in response to Barry

Thanks Barry

I knew there had to be a way.

Erik

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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 Account.

Learn more Sign up