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

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.