okHi sadasivan,
I think its not possible to see hidden formulas in protected sheets.
I am sure one of our Ninja will confirm.
Hi,Ok
but my case is different . actually I dont know the the password
this is a sample file i upload as referene
I doubt bro...because it never works for me...HI,
Do you want to view all the formulas in the protected worksheet.
Formula Tab<Show Formulas.
This will display all the formulas even when the worksheet is protected.
You can only view the formula, you will not be able to copy the formula.
Hi Asheesh / Khalid ,
Srinidhi is right ; see the following link for the reason :
http://www.mrexcel.com/forum/excel-...ms-viewing-formulas-when-sheet-protected.html
Narayan
Thanks brother for update.@ Khalid NGO.
I am using excel 2010 & both option work for me.
Formula Tab<Show Formulas. (short key Ctrl+~). I am able to view the formula, but unable to copy them as they are protected.
Hi Asheesh ,@NARAYANK991 - I agree what is written in the above link...Yes, indeed we can see the formula if the hidden property of the cell is unchecked...however, it will not work if all the cells are hidden and protected...unless used some external source to break the password.......and as per the question -- sheet is protected and the cell property is hidden..(thatz what i understood and was trying to find out)...please correct me if i am wrong