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.
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.