I have the fillowing formula in M2:
I would like to copy this formulla to an unspecified (ie varied) number down column M. I use the method of going to the location area in the top left of the screen, and type in M2:M30000 - for example.
I then hit Ctrl D and Enter - and the formula copies down. However, D2, changes to D3, D4, etc.
Please offer how I can maintain D2 all the way down the column.