Forum Discussion
Dre_Compomizzi
Sep 24, 2021Copper Contributor
Copying a formula down a row while keeping one cell constant
Hello, I am really new to Excel, and I was wondering if there is a way to copy a formula down throughout a column, while keeping one of the cells the same. It's probably best if I write an examp...
- Sep 24, 2021Use $Y$2. That will fix the reference.
Riny_van_Eekelen
Sep 24, 2021Platinum Contributor
Use $Y$2. That will fix the reference.
Wade_Grimm
Jun 30, 2024Copper Contributor
Thank you Riny, this helped me too. A whole bunch and many thanks