Forum Discussion
Solved
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...
- Use $Y$2. That will fix the reference.
Use $Y$2. That will fix the reference.
- Thank you Riny, this helped me too. A whole bunch and many thanks
- I cant remember the keystroke(s) to set a cell as a constant.
- Never mind. I just remembered. Its the F4 key! Thanks just the same.
- Thank you so much!
