how to remove formula in excel sheet-urgent

make a double click on the cell where formula is putted then delete that formula

thanks........its a long sheet......so any other idea??

you only have to delete the formula from the cell where the ultimate answer will come not on the whole sheet

Just Copy the cells where u want to remove the formula (shortcut (Ctrl +C)),

then right click on the cells and click on paste special,

then the window comes that has many options, just click on values and press OK

it will remove all formulas and paste the values of the cells as it is.

Thanks, 

Varun Arora

select all which you want to remove formula then copy all and click right button in colum A1 and past special  select value then ok its remove all formula and your data is safe .

if you want to delet all data then slect all and delet selected row. file will be blank.

sir ji paste special karne se jis cell ko copy kiye ho uspe jo bhi entry karoge wo bhi copy ho jayega

Can you share that file with us so will come to know your problem

Varun Arora & Rav Avatar Singh are Rite. 

thanks VARUN.............n RAM.......it works

If you have basic knowledge of how macro work in Excel, 
Then this is the code for the macro.


Sub RemoveFormulas()
Dim ws As Worksheet
For Each ws In Worksheets
  With ws.UsedRange
    .Value = .Value
  End With
Next ws
End Sub

Visit - XBRLforIndianCA.blogspot.com