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
Was looking for a way to solve this, and found a work around that is not too much extra work.
- Select the cells you'd like to move and right-click drag them to their new location.
- Select the option "Copy Here as Values Only".
- Remove the values from the old location (select the cells and press Delete).
Would be nice to have a "Move Here as Values Only" option, but hey, when life gives you lemons..