Copy data validation and maintain cell reference?

Hi All,

I have a problem when copying data validation to other cells. When copying, the cell always increments by one and I need the reference to stay the same.

Here is a sample of my data validation formula: =MOD(P35,$A1)=0

Now if I copy that to the cell directly below, the formula becomes: =MOD(P36,$A2)=0 and the next row becomes =MOD(P37,$A3)=0 and so on.

I want the reference to remain $A1.

Such as:

=MOD(P35,$A1)=0
=MOD(P36,$A1)=0
=MOD(P37,$A1)=0

I can't for the life of me figure out how to keep the reference for $A1 and not increment when pasting.

The worksheet I have now is only a few dozen entries and I was comfortable manually changing everything back to $A1. But I now have a worksheet with several thousand rows of data and it would be so helpful if there was a way to copy and paste the data validation formula and always maintain the reference as: $A1.

If anyone could offer a suggestion, I'd appreciate it.

Thanks!

Please try =MOD(P35,$A$1)=0

Thank you! This works perfectly.

Thanks for the feedback and rep . Glad to have helped.