Paste Special Values in Excel

preview_player
Показать описание
This video shows Dr. Evan Matthews explaining how to copy values in cells containing formulas and paste the result of that formula using paste special values. This removes the formula from the cell you are pasting the data into and leaves just the end result of the formula.

Excel Skills Playlist

Link to Dr. Evan Matthews website.
Рекомендации по теме
Комментарии
Автор

Paste special is not working on my pc..only 3 options are showing up..1st one is as html, second as text and 3rd as unicode text pls help

abhinnsharma
Автор

How can you protect a cell, so that when you paste into it > it can only paste values by default? I have alot of people working on an excel document, and I ONLY want paste values being entered (I cant trust the users to always remember to use paste special)

Danny-Do-It