Excel auto-formats cells when cut & pasting

[JasonNH]

I have one file which behaves strangely. When I cut an area and paste it elsewhere, the orginal area, or just a part of it, is formatted. Normally cells are not formatted after a Cut and paste. Tried to look everywhere for a setting to turn this off with no luck.

I know I could use Paste special with shortcuts as a workaround but would be very happy to know why this file does this. In addition cleaning those formatted cells gets a bit old.

Thanks for your answers

 

[Joe4]

Yes I know. Did you read the question? Problem is that the area where cutted from gets formatted, in normal operation Excel leaves it unformatted.

Yes, I did read it. Perhaps I am not understanding what you are asking. Let's try to clarify it a bit.

How exactly is the original range being "auto-formatted"?
Are you cutting/pasting data out of a table?
Is your intention to copy just the data and not the formatting to the new area?

 

[JasonNH]

Yes, I did read it. Perhaps I am not understanding what you are asking. Let's try to clarify it a bit.

How exactly is the original range being "auto-formatted"?
Are you cutting/pasting data out of a table?
Is your intention to copy just the data and not the formatting to the new area?

Thanks for answering!

I just need normal functionality: Cut everything from selected range (values, formulas, formatting) paste it somewhere and leave original area blank. Blank as cells are in a new workbook.

Now they are colored green and have border as you can see in my Pic. It's before-after picture.

I have used this exact formatting elsewhere on this sheet. Would like to know why part of "new" cells get this formatting automatically.

 

[Joe4]

Not sure why that might be happening.
If you are willing to upload a copy of your file to some file sharing site (after removing any sensitive data) and post a link to it here, I would be happy to take a look at it.