Moving sheets w/o losing formatting

[musictatter]

I am needing to move a sheet to another file. When I do I lose all the formatting. Background colors, size, comments, etc. Is there a way to save that while moving a sheet?

Added: I am a curator of a cemetery and have created a map with TONS of information. I am learning as I create these sheets. But I need to combine files to simplify the information for future volunteers.

Thank you so much!

[F3K Total]

hello,
open source and target document, in source document rightclick on the sheets tab, Move/Copy Sheet...

MCS.png (9.35 KiB) Viewed 1596 times

will keep formatting, comments ....
R

[musictatter]

I did that.. Lost all background colors, borders, etc.

[RoryOF]

I have just now tested - this kept the formulas and background colours of my original.

[Zizi64]

I did that.. Lost all background colors, borders, etc.

Please upload two sample files here (to demonstrate the before/after state)

[John_Ha]

have created a map with TONS of information.

If you have tons of information a database may be a better solution.

If you persist with a spreadsheet you find it sensible to protect some? many? all? cells with data against change.

[RoryOF]

Would loss of formatting be due to the file format? Save as .ods and try again.

[musictatter]

Because of privacy of the names I'll have to change some things first.

[RusselB]

While you're anonymizing the data, help for which can be found in [Forum]How to attach a document also please note that we don't need all of the spreadsheet, just enough that the sheet you upload also shows the same problem.