How to get formula to show Column Header with “Preserve Row”? Why does Column Header switch to Address?

I need help with preventing column header changing to address when “Preserve Row” is enabled

iPad mini (6th generation)

Posted on Apr 24, 2023 2:47 AM

Similar questions

Why does my header formula change as I add rows? I don't want it to change. My header needs to display a number, which is calculated as follows: B2-B3. Whenever I add a row, the header formula automatically changes to B3-B4. I don't want that to happen. I need the formula to remain as B2-B3 as I add rows. I tried using $B$2 and $B$3 instead, but that didn't help. The formula still changed. This is the original formula when I had two rows: As I added a third row above, the formula changed: How can I prevent it from changing? Thank you in advance.
544 2
Cannot select cells when entering formula. After I enter into formula typing I have to wait a few seconds or click several times to select cells. I can type cells or anything but cannot select cells. Couldn't find any related thread and ran out of ideas, please help.
706 7
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?
998 1

1 reply

Apr 26, 2023 4:46 AM in response to SunnyInToronto

Solution is to remove colon characters from Headers

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.

How to get formula to show Column Header with “Preserve Row”? Why does Column Header switch to Address?

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