How to drag a formula with only incrementing one of the cell values

Occasional Contributor

I want to drag I4 down to row 900, however I only want the cells from THIS sheet to increment by +1. I do not want the cells from the DataConstants Sheet to be incremented.
Is there a way to do this?


2 Replies
best response confirmed by SteveDatz (Occasional Contributor)
Use $ to fix this...$A$2 - Both column and row are not impacted by dragging.
Hence, in your formula wherever you have referred to DataConstants Sheet, use cell references with $.
Don't put $ against cell references of this sheet.
Hence your formula would be