Ask Your Question
0

How to prevent cell formatting being removed when values are cut

asked 2020-05-25 13:33:30 +0200

danix gravatar image

I have a long list of items I need to manually move around. So I need to cut and paste things to move them in different position on the list. This cut operation naturally deletes all formatting from those cells so when I want to type something into those cells later I need to add all my formatting back manually. Is there a way to make the cut operation just to copy and delete the cell contents but leave the formatting alone?

edit retag flag offensive close merge delete

Comments

.. only if you select the content by double clicking into the cell (or entering the cell edit mode F2) and selecting the content before you cut (There is no Cut Special like there is a Paste Special and Cut means to cut everything thing from a cell and a cell is content+properties).

Opaque gravatar imageOpaque ( 2020-05-25 14:27:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2020-05-25 17:00:39 +0200

LeroyG gravatar image

updated 2020-05-25 17:01:52 +0200

danix,

Moving with the mouse, actually would cut the content and paste it in the destination.

The simplest solution (who works for me) is to Select (with mouse and/or keyboard), Copy, press Delete key, select the desired destination (upper leftmost cell) and Paste.

If do you want to maintain the format of the destination, just Paste Special (selecting only Text, Numbers, Date & Time). Insert key should do the same as Ctrl+Shift+V.

Delete will not affect the cell format. Using Backspaceis a two (or three) steps process.

edit flag offensive delete link more

Comments

Thanks, this copying and then instantly deleting feels like the easiest solution!

danix gravatar imagedanix ( 2020-05-25 19:25:41 +0200 )edit
0

answered 2020-05-25 16:07:17 +0200

JohnSUN gravatar image

Try not to CUT cells, but just COPY. Then return to the original range and press Backspace, clear all but the formats.

NotClearFormats.png

An alternative way is to cut out the cells, paste in the right place, go back to the original range and use Ctrl+Shift+V (Paste Special) to paste only the formats

PasteFormats.png

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-25 13:33:30 +0200

Seen: 23 times

Last updated: May 25