Ask Your Question

copy the formatting from one sheet to another sheet in calc

asked 2020-01-02 22:09:49 +0100

clos911 gravatar image

updated 2020-01-02 22:10:13 +0100

I have a calc file with a few sheets, my main sheet has conditional formatting on columns A thru M, the conditions are for numbers and will trigger a style for the number. pretty standard.

I would like to copy or = only the formatting on my main sheet onto another sheet in the file in the same corresponding cells. I do not want to copy the number. I would like it to copy whether it's the conditional formatting style or the default style.

thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-02 22:38:30 +0100

Copy the cells/rows/whatever you need, then EditPaste SpecialPaste Special...; and in dialog, unselect everything except Formats.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-02 22:09:49 +0100

Seen: 527 times

Last updated: Jan 02 '20