When we use the very common keyboard shortcuts to copy
Ctrl + C and to paste
Ctrl + V it will copy everything including values, formulas, formatting, comments/notes, and data validation. That's a lot! Sometimes we want to copy only the values and not any of the other stuff in the cells.
Let's cover 8 ways to copy and paste only the values from your Excel data.
This example contains a lot of formatted data, such as:
- Font color, fill color, number formatting and borders.
- SUM formula
- A data validation drop down list.