|As I said in the other post:|
just drag down
Select the cell K2,
notice the small black square in the lower right corner
Move your cursor over the small square
and it will turn into a thin black + sign
With the + sign displayed, drag down.
Copy/Paste will work, but it has to be
Copy / Paste / Special / Formulas
I should have been a bit more specific:
With the + sign displayed, Left Click & Hold, then drag down.