Stop auto update of Cell reference when copying

I have a formula in a Cell lets says it is ((C2 + B1) * A1). When I drag that cell to another all the variables are updated to ((C3 + B2) * A2). I want the first to update but I want A1 to stay A1. In this case A1 represents an interest rate that I want to vary at will.


Thanks

MacBook Pro 14″, macOS 15.6

Posted on Sep 19, 2025 11:34 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 19, 2025 11:50 AM

Replace “A1” with “$A$1”. This is the fixed cell reference format.

2 replies

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.

Stop auto update of Cell reference when copying

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