Pasting text in calc

LO 25.8.22

How to paste text in Calc without losing the cell format?

If the text is a copy of a different Calc cell:
>Edit>Paste Special>Paste Unformatted Text or Ctrl+Alt+Shift+V.
If it comes from an external source:
Shift+Ctrl+V, then select Unformatted Text.

If you want to retain the internal formatting of portions of the cell’s text:
Shift+Ctrl+V (>Edit>Paste Special>Paste Special...), Text enabled,

Only works with single row paste, how can I paste multiple row on a single row without losing the cell format? I don’t know if what I type makes any sense, but I don’t know how to explain it.