View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default How do I keep fill color constant when cut & copying text?

Instead of Paste, use Paste Special - Values. That will leave the formatting (color) as it
was in the cell into which you're pasting.

Be careful cut/pasting stuff if there are formulas in the worksheet referring to these
cells. In some situations, it can cause the formulas to change.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"bwcland" wrote in message
...
This is for a basic Excell spreadsheet with columns and rows. I've used
white & yellow as the row fill colors for clarity when viewing the
spreadsheet.

When the information in a yellow cell is cut (or copied) and then pasted
into a white cell, the fill color turns yellow from the previous location.

Is there a way to keep the fill colors constant for each row, and only allow
the text to change when relocating to another cell?

Thanks!