•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Misunderstanding cell referencing. The copied formulas are acting like I have put an absolute cell reference when it should just be the Column locked not the row as well.
Hello all, I am trying to understand why my formula is acting like I have an absolute cell reference in cell B32 when I set it to keep only the same column(column B). I wanted to copy this simple formula across columns, but the copied formulas stay column B and row 18. I thought if I put $ in front of the column only the row would change with the formula, but it did not. What am I not understanding about cell references here. For reference, the values in B32, C32, and D32 are what my formulas in cells B34, C34, and D34 should amount to. Any help would be appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#row zero
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#cell referencing
#formula
#absolute cell reference
#copied formulas
#formula across columns
#column locked
#Excel
#values in B32
#B32
#cell B34
#copy
#row 18