Convert Formulas Into Values Using Paste Special Excel Quick Tips

Using Paste Special for Converting to Values – Excel Quick Tips.
If you are sending a report to someone without its source data then it’s better to convert all the formulas into static values.
To do this, select your data range or the entire column.
And then, right-click and copy it.
Go to Home Tab. Clipboard. Paste. Paste Special. Select values. Then click ok to paste.
Or, you can also press right-click and go to Paste Special, Values.
This method just works like the shortcut key method to replace all the formulas with their static result values.
#igorotech #igorotech #ComputerKnowledge #ComputerTips #Shorts #ExcelQuickTips