Keep formatting in original cells. What are my options?

Maybe this is not possible, since when I Google it, there seems to be no answer, though Google does keep rephrasing my question, so I can't seem to get relevant results.

Anyhow, I have columns of data that expands from B to BG. For each roll, I have to move data between these columns (B-BG). I usually just copy and paste, but that is aggravating, because I have to scroll all the way back to where I copied it, and then delete it. And doing this constantly from a phone is frustrating. So you probably think I should be cutting instead of copying, but that's where the problem starts. If I cut, Excel assumes I want to remove the formatting of the cells, which I do not.

So, is there a way to cut and paste without affecting the formatting of the cell you're cutting from, or is there a way to copy and paste, and have Excel delete the original automatically?

Originally Posted by Modify_inc

is there a way to cut and paste without affecting the formatting of the cell you're cutting from, or is there a way to copy and paste, and have Excel delete the original automatically?

The short answers are: no and no.

WRT to cut-and-paste: that's the way that Excel works. I don't see an option to change that.

WRT to copy-and-paste: what you ask for violates the common-sense meaning of "copy". What you describe is, in fact, "cut".

In a PC version, I would write a macro. But I'm not familiar with the features of phone versions of Excel.

As far as i know there is no way to keep formatting when cutting a cellvalue
I think using conditional formatting may help you here.

Make two rules on to be valid for empty cells and one for nonblank cells but both with the same formatting
This way the same format will be shown always.

Using an excel table may also help in keeping the format of the cells when you cut and paste within the same table

There is only one answer that questions the organisation of data the other three explain why it cant and what are workarounds..

Originally Posted by Roel Jongman

There is only one answer that questions the organisation of data the other three explain why it cant and what are workarounds..

Yes, I'm sorry about that. At the time, she was the only one that replied, and then I forgot to hit the reply with quote option. I guess I could try editing it.

Thank you for your suggestions and feedback. I do appreciate it.