Page 1 of 1

Moving sheets w/o losing formatting

PostPosted: Mon Dec 02, 2019 6:56 pm
by 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!

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 7:08 pm
by F3K Total
hello,
open source and target document, in source document rightclick on the sheets tab, Move/Copy Sheet...
MCS.png
MCS.png (9.35 KiB) Viewed 456 times
will keep formatting, comments ....
R

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 7:50 pm
by musictatter
I did that.. Lost all background colors, borders, etc.

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 8:05 pm
by RoryOF
I have just now tested - this kept the formulas and background colours of my original.

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 9:04 pm
by Zizi64
I did that.. Lost all background colors, borders, etc.


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

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 9:26 pm
by John_Ha
musictatter wrote:[I] 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.

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 9:29 pm
by RoryOF
Would loss of formatting be due to the file format? Save as .ods and try again.

Re: Moving sheets w/0 losing formatting.

PostPosted: Mon Dec 02, 2019 11:44 pm
by musictatter
Because of privacy of the names I'll have to change some things first.

Re: Moving sheets w/0 losing formatting.

PostPosted: Tue Dec 03, 2019 4:56 am
by 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.