Cut & Paste problem.

[MarkDave]

Do you know how to cut nd paste information from one cell to another whilst keeping the source / destinaton formatting?

 

[jbeaucaire]

Highlight source cell(s) and press CTRL-X

Click on destination and press ENTER. Formatting is kept during this technique.

 

[MarkDave]

Cheers mate....doens't seem to work though.

The cell borders, colours etc of the source cell still move...

any ideas? Surely there has to be a way?

 

[VoG]

Copy (not cut).

In the destination cell Edit > Paste Special, tick Values, click OK.

Delete the original.