Ask Your Question

How do I create new cell styles that can be used in other spreadsheets?

asked 2020-05-21 12:04:09 +0100

kdev gravatar image

I've created some cell styles in a spreadsheet and I want to use these styles in other spreadsheets already created and in future spreadsheets.

How can i do this? Or at least, how can i load other cells styles without creating them again?

Note: The goal is to use these styles in conditional formatting

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-05-21 12:45:57 +0100

Lupp gravatar image

Simply copy cells having assigned the wanted styles from the source sheet and paste into the target sheet.
If the chosen style names aren't already used by the target document, the new styles will be imported.

Predefined styles having the same names are not overwritten. The pasted cells get assigned the locally applicable styles of the chosen names instead. Direct attributes survive.

edit flag offensive delete link more


Great, it was easier than I thought. Thanks :)

kdev gravatar imagekdev ( 2020-05-21 13:03:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-21 12:04:09 +0100

Seen: 54 times

Last updated: May 21 '20