Cell shading not going away

[RamyJo]

I have a question about cell shading. I have just started recently using cell shading more than normal and I've encountered a issue with a work spreadsheet that I can't figure out which option to change to make it go away. The spreadsheet that I'm working with has 20 columns and they are each shaded a different color. When I cut and paste data from one cell to another the original shading color stays the same which is fine but the original cell that I cut from stays shaded as well. I want the cut cell to go back to being blank afterwards (see screenshot below). Thanks in advance for any and all help!

~Ramy Jo

 

[Michael M]

Are you cutting or copying ?
Is the shading by conditional formatting ?
Are the ceclls merged ?

 

[RamyJo]

Hi Michael,

I have tried both cutting and copying but same issue both ways. The cells aren't merged and no conditional formatting. Since I wasn't the one that originally made the spreadsheet, I think I'm going to start a new one and enter all the data myself so that maybe I won't have this issue there.

 

[Michael M]

Can you upload the workbook to a hosting sites, Dropbox for instance, I can't replicate your problem

 

[RamyJo]

I think I may have figured it out,. I had to add a few new columns to the spreadsheet this afternoon so I decided to format them differently to see where issue with cut and paste may be coming from. So for column M I clicked on the top of the column and then clicked my fill color (that way the entire column was shaded). Then for column N I clicked on the first cell with data in it and then move my mouse down to the last cell in that column with data and then I shaded just those cells. I found out that if you shade the entire column that when you cut or copy the cell and paste it somewhere else then the original shading stays but if you only shaded the cells with data then if you cut and paste the original cell was go back to its original state with no data or formatting of any kind. But if you copy and paste then the original cell will stay shaded.

 

[Michael M]

That's correct...Entire column will maintain whatever formats are put in place...