Excel formula

This query is : Resolved 

27 June 2011 Please let me know how do i inactive formula bar in excel i.e people does not see the formula written in the excel cell while want to see the formula of a numeric value

please help

27 June 2011 u have to first protect the sheet (with or without password), then use 'format cells' (Ctrl+1) > Protection Tab and checkmark "Locked" and "Hidden",,
To Protect sheet, under "review" Tab, click 'protect sheet'

28 June 2011 Dear you select cell open format pop up - protection- click on hiden
Then goes to tools - protection - click on Select loked cell& unloked cell press ok

following this

http://www.techonthenet.com/excel/cells/hide_formulas2010.php




You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries