Support Board

Date/Time: Wed, 15 Jan 2025 18:53:35 +0000

Post From: spreadsheet copy down without reference auto-correcting itself

[2017-07-21 08:25:11] Link To Thread - Link To Post [Go To First Post]
traderacademie - Posts: 38
Hi, I am using the spreadsheet with formulas with referenced cells e.g.: =IF(9<ID2.SG1@3<19,1,0) Then, I use the "copy down" feature to copy the this formula to an adjacent cell and the formula changes to: =IF(9<ID2.SG1@4<19,1,0) So, the reference automatically updates itself. Now this is handy in some cases, but in my case I just want to copy the exact formula without auto update. Is this possible? If yes, could you tell me how? Thanks Rgds Will