8 Ways to Copy and Paste as Values in Excel

Jan 3, 2021 1 min read
8 Ways to Copy and Paste as Values in Excel

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.
Great! Next, complete checkout for full access to ArturoFM.
Welcome back! You've successfully signed in.
You've successfully subscribed to ArturoFM.
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info has been updated.
Your billing was not updated.