There should be an option to paste inserting rows rather than replacing the data.
In spreadsheets, let's say i have columns that have the following data in them: 1, 2, 3, 4, 5. I want to copy 2 and 3 after 4. I want to get 1, 2, 3, 4, 2, 3, 5. But I cannot, as pasting rows does not insert them, but overwrites the data in them: I get 1, 2, 3, 4, 2, 3. The same goes for cutting. There should be a setting or contextual option that allows me to choose whether I am inserting the data, or overwriting it.
1
vote