Forum Discussion
Moving cell content without moving cell format
Hi, I simply want to move the content of a cell without impacting the format of the cell. I don't want to use cut and paste value only but move the content
Hello, was looking for an answer to this same question, and I found a work around that is not too much of a hassle.
- Select the cells you want to move and right-click-drag them to the new location.
- Select the option "Copy Here as Values Only".
- Delete the values in the old location (select original cells and press Delete on your keyboard).
Would have been nice to have a "Move Here as Values Only" option, but hey, when life gives you lemons...