Forum Discussion
Pasting new data into a table, without deleting conditional formatting
Hello,
I'm wondering if there is a way to avoid having to paste values when adding data to my worksheet/table, as just a simple ctrl v is removing the conditional formatting from my sheet for those cells.
The worksheet has 13 columns where column 2-4 are used to paste data every day. However, when I do this it removes my conditional formatting from these 3 columns.
Is there a way around this or is ctrl shift v my only option?
Thanks!
If you are using Excel for the web, maybe you can try using the Paste Options feature to paste only the values without removing the conditional formatting. See the upper link.
Haven't tried it myself, should actually work with All merging conditional formats (Pastes the contents and conditional formatting options from the copied cells).
