Hi Friends
Can any one tell me that how can we hide formulas applied on a cell, with no change in its formatting.
Thanks
RAMANJU
(here to updating the knowledge)
(485 Points)
Replied 16 February 2010
Just copy the particular cell and do paste special only values by selecting in edit on toolbar.
SSG
(1936 Points)
Replied 16 February 2010
I have done this, but this distorts all the formatting of the excel sheet.
CMA Ankur Pandey
(Govt.Job)
(4401 Points)
Replied 27 February 2010
hi ssg
hiding a formula is different than having value in cells
plz clarify more about your requiremnet
SSG
(1936 Points)
Replied 27 February 2010
I just want to show values in the cells and hide the formulas and at the same time keep the format of the cells unchanged.
Kamaraj Mani. N
(Chartered Accountant - Product Manager)
(553 Points)
Replied 08 March 2010
I hope, you are expecting this... if no, tell us clearly what exactly you want.
Do the following:
1. right click the particular cell > Select Fromat Cells > Select Protection Tab
2. Select Hidden Option Button
3. Click OK Button
4. Protect the sheet with Password.
5. Close the workbook and open it again.
6. Check now, the particular cell will not show the Formula...
KUMAR trp707@gmail.com
(TAX RETURN PREPARERS )
(990 Points)
Replied 17 October 2010
sir
good help for ours, nice guide with snap shot
Master GSTR-9 and 9C with India's First Unique Live Course with Live practical training
LIVE Form 10 B and Form 10BB: Handle Tax Audit Reports of Charitable Organizations(without recording)
CAclubindia
