Hide formula

  • Thread starter Thread starter Guest
  • Start date Start date
Anand vijay

I am confused, if you hide the formula you hide the results of the formula.
If you are doing this to use the results for another computation, why not
incorporate your formula into the other formula? or just color the font
white?

Mike Rogers
 
Anand

Format>Cells...>Protection>Hidden and then protect the sheet will not show
the formula in the formula bar, but I suspect that's what you don't want.

You could turn off the formula bar via Tools>Options...>View>un-check
formula bar?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel EXCEL - using a date dependant formula to hide rows 3
Hide formulas 4
Formula Encryption 1
Hiding Formula's 2
Access Textbox - Hide Cursor 0
Command Bar (formula bar) 2
hiding rows 3
Setting Error #VALUE,#REF,#NAME, etc. 6

Back
Top