8 Ways to Copy and Paste as Values in Excel

Arturo -

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:

  1. Font color, fill color, number formatting and borders.
  2. Notes
  3. SUM formula
  4. A data validation drop down list.