Remove Formula and keep the data in Excel (3 Simple Ways)
Do you want to remove the formula and keep the data as is? In this video, I will guide you three simple methods to remove the formula and keep the data as it is Excel. The 1st and 2nd method is using Paste Special. You will need to copy the existing cells - which have the formulas that you want to remove - and replace these with values only by using the Paste Special dialog box.
3rd method to do this is by using a less-known mouse trick.
Select a range of cell, place the cursor at th
e right edge of the selection, hold the right mouse key and move it a little to the right and then bring it back. It will show you a menu that will have the option to 'copy and paste as values'.
This video is a part of my 'Excel is 2 minute' series.
Shortcut keys used in this video -
Paste spcl - Alt+E+S+V
Please subscribe to my channel and click on bell icon to get new video updates.
#MSExcel#ExcelPathshala