Sometimes I need to copy the value of a cell to several one.
If I click the cell and drag it it tries to continue the logic of the values in the cell.
So makes sense that I click copy, select several cells, and paste... but that doesn't work.
And if I try copy a value from a cell to the one underneath it, then it deletes the value of the one under the new one.
Say I have
- A1 that is "value 1"
- A2 that is "value 2"
- A3 that is "value 3"
If I copy A1 to A2, then A2 is "value 1" but A3 becomes blank... So I am always deleting a row under the one I am pasting to the point is deletes something important
Sometimes I need to copy the value of a cell to several one.
If I click the cell and drag it it tries to continue the logic of the values in the cell.
So makes sense that I click copy, select several cells, and paste... but that doesn't work.
And if I try copy a value from a cell to the one underneath it, then it deletes the value of the one under the new one.
Say I have
If I copy A1 to A2, then A2 is "value 1" but A3 becomes blank... So I am always deleting a row under the one I am pasting to the point is deletes something important