How to insert & paste data in Libreoffice Excel Sheet.

Copy data & put square box wherever you want to paste the data

then click insert button on keyboard.

one window (paste special) will come out.

then check out Down option ( Alt+ W) under shift cells column.

u have other options also available as Don't Shift & Right.

then click OK.