Excel drag and drop cells
Say I have the number 1 in cell A1.
If I select the cell and drag it down, I will 1,2,3,........all in column A.
If I have and X in cell A1 and do the same, I get X,X,X,X....all in column A
Dates and number advance by 1 unit, but test stays the same.
I want to drag and drop a date, but keep it the same date, not advance. Is there way to turn off the repeat function? I an only find how to allow or not allow drag and drop.
Thanks
__________________
Who does the Racing Form Detective like in this one?
|