How to Copy Paste Only Formula or Value in Excel

Easy way to copy and paste formulas in excel is 

Right click on the cell containing formula and select 'copy'

Then go to destination cell where you want the same formula and right click on that cell. 


Select 'paste special' option from context menu*


Paste Special dialog box 

Select / Check  'formula' from paste special dialog box then click OK



The same formula only will be pasted in the cell 






By using paste special dialog box we can paste only values and formulas and formulas and number formats also.



* context menu is the bunch of options appears when the right button of mouse is clicked