Help with copy and paste.

V

Vipulparbat

I have a spreadsheet which has an area for data, and then a summar
table with conditonal formatting which changes the colour of the cell
depending on the value.

I would like to copy and paste this summary table into a ne
spreadsheet and preserve all the colour changes. How can I do thi
without copying all the data with it.

I have tried but find that only the text and formats can be copied an
I have to manually change the colours again.

Any help would be appreciated
 
B

Beege

"Vipulparbat" <[email protected]>
wrote in message
I have a spreadsheet which has an area for data, and then a summary
table with conditonal formatting which changes the colour of the cells
depending on the value.

I would like to copy and paste this summary table into a new
spreadsheet and preserve all the colour changes. How can I do this
without copying all the data with it.

I have tried but find that only the text and formats can be copied and
I have to manually change the colours again.

Any help would be appreciated.
Click to expand...
Vipulparbat,

Did you select the sheet tab, right click, move or copy (keep a copy) to
create your sheet copy? I would preserve everything.

Then you can Edit/GoTo/Special/Constants and then delete data but not
formulas, not formatting.

I'm no expert, but this might help...

Beege
 
Top