Hi Friends
Can any one tell me that how can we hide formulas applied on a cell, with no change in its formatting.
Thanks
8 Replies
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
Recent Topics
- GSTR-9 Invoices
- Agricultural Business Loss
- Reporting in gstr9 of ITC of Previous year reverse
- Tax on Reimbursement of House Rent
- MAHARASHTRA CHARITY COMMISSIONER WEBSITE
- Explanation 3 to section 11(1) read with section 4
- Ammendment in Partnership On Death of Partner and
- TDS Provisions applicability Tax Audit Individual
- NAME CHANGE OF HUF
- Advisory for Reporting TDS Deducted by scrap Deale
Related Threads
CAclubindia
