Is there any way to use the cross in the bottom right corner of each cell to drag a formula with some cells that vary, but others that remain constant?
For example:
If I want the formula to be:
B2+C2
B3+C2
B4+C2
B5+C2, etc.
Is there a way to drag "B2+C2" down to make it look like the list above, rather than dragging it down to see:
B2+C2
B3+C3
B4+C4
B5+C5, etc.
Thank you!
Bookmarks