Teach Yourself Excel Lesson 17 - Copy And Paste Special Values

Nick's picture


Copy And Paste Special Values

Download starting Sheet

We've just learnt how to enter a formula, so this lesson is on how to convert the formulae to values.

Steps:

  1. Press CTRL + G (to go to a range)
  2. Type: F:H
  3. Press OK
  4. This selects columns F to H - the columns that contain the formulae
  5. Press CTRL + C  (to copy)
  6. Press in sequence:  ALT then E then S then V   OK

Click on cell F2, and you will now see that it is a value instead of a formula.

NOTE:

  • If you change a date in column A, the values in columns F to H will not change any more.
  • So, only copy and paste special values if you don't want your sheet to calculate any more.
  • Use copy and paste special values to reduce your sheet's complexity when you're sure you don't want them to calculate any more or to take snapshot of some data.

Your sheet should now look like this

Next Lesson: Teach Yourself Excel Lesson 18 - Protection

Training Video on how to Copy And Paste Special Values in Excel:

AttachmentSize
copy-and-paste-special-values.xls29 KB