LibreOffice Calc: How to paste cells without overwriting other cells

The default behavior of Calc is that when you paste cells from the clipboard, it overwrites whatever cells occupy the same space on the spreadsheet. If you would like to insert the cells in the clipboard instead by pushing the existing cells to the bottom or the right, you can do it like this:

• Go to Edit / Paste Special
• The paste dialog has a segment Shift Cells. Choose Down or Right depending on what you want to do.