sites all seem to say go to

tools > merge

to do this; except there is no such item in this install of LibreOffice.

Any ideas?

Hi,

On my Fedora 31 with LibreOffice Calc 6.3.6, I do the following 3 actions:
select the cells that I want to merge
right-click on them
use command 'Merge Cells'

Or from menu Format -> Merge Cells -> ...

I hope it helps.

1 members found this post helpful.

Sorry if I wasn't clear -

I want to merge whole spreadsheets of similar info from different sources into one big file - experimenting with your suggestion resulted in complete overwrite, not merge. Thanks tho.

Here's why:

Bitwarden Password Manager has started losing info. I export my data regularly to protect it, so I have all of it still, including what Bitware has lost. I want to merge all the exports and edit it before importing it all back into Bitwarden.
This is the 3rd or 4th time it's happened, too, I don't know why I'm still using it.

Hi,

OK.

I have no idea what Bitwarden is and does.

My suggestion is, supposing you do no care neither need the formatting, to export every in tab separated files.
From those you should then be able to achieve the merging you need.

Try this (works for me):

Open both documents simultaneously. Say you're about to copy all tabs from file A to file B.
Activate file A.
Right click at the tab in the bottom, select "Move or Copy sheet".
In the following dialog box, under Location select file B.

And click OK.

1 members found this post helpful.

Thanks.
That's what I needed.