Hello Everyone,
I am currently using Excel 2000 and I was wondering if someone could help me out, I would imagine this has been fixed in newer versions but I am not sure.
Say you have Column A the first three rows have a fill color of RED
The rest of Column A has a fill color of YELLOW
Rows 10, 11 and 12 have text in them (with YELLOW filled background)
If you select 10, 11 and 12 and go to cut
Then you paste them in Column A in Rows 1, 2 and 3
Rows 1, 2 and 3 will have the data and the YELLOW fill pasted in them (which is great)
but left behind is rows 10, 11 and 12 and they now are no longer YELLOW, they are now WHITE
The fill color gets removed completely, where I wanted them to stay YELLOW as well..
Is there a simple way to prevent this from happening?
Would imagine a macro could fix this, but it seems like it would be overkill for something that I hope has a simpler solution.
If anyone has any advice, please share.
Thank You to anyone who reads this
(Sorry to hear about the attacks on this site, seems odd that so many forums seem to be having problems like this, what would be the point of doing something like that, to an Excel Forum?)
I am currently using Excel 2000 and I was wondering if someone could help me out, I would imagine this has been fixed in newer versions but I am not sure.
Say you have Column A the first three rows have a fill color of RED
The rest of Column A has a fill color of YELLOW
Rows 10, 11 and 12 have text in them (with YELLOW filled background)
If you select 10, 11 and 12 and go to cut
Then you paste them in Column A in Rows 1, 2 and 3
Rows 1, 2 and 3 will have the data and the YELLOW fill pasted in them (which is great)
but left behind is rows 10, 11 and 12 and they now are no longer YELLOW, they are now WHITE
The fill color gets removed completely, where I wanted them to stay YELLOW as well..
Is there a simple way to prevent this from happening?
Would imagine a macro could fix this, but it seems like it would be overkill for something that I hope has a simpler solution.
If anyone has any advice, please share.
Thank You to anyone who reads this
(Sorry to hear about the attacks on this site, seems odd that so many forums seem to be having problems like this, what would be the point of doing something like that, to an Excel Forum?)