Forum Discussion
Solved
Copy/paste with conditional formated cells
Good evening,
I have two cells which are locked and theoricaly no formating enabled.
When I copy the first cell to the other one, the formating is copied to on the other cell.
How can I paste values without modifying the formating, even with locked cells?
Thanks!
- To paste values without the formatting.
1. Copy the cells that has values and formatting using CTRL + C
2. Select destination cell where you want the values to be pasted
3. Execute ALT + HVV
That value will be pasted without the formatting
1 Reply
- To paste values without the formatting.
1. Copy the cells that has values and formatting using CTRL + C
2. Select destination cell where you want the values to be pasted
3. Execute ALT + HVV
That value will be pasted without the formatting