Hide formula

M

Mike Rogers

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
 
N

Nick Hodge

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
 

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

Place picture in Excel cell 0
Mis-performing MP4 files in Mac PPT 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Customised ribbon disappeared from Word docs. 0
Copy addition formula of non-consecutive horizontal cells 2
Hide columns based on row values 2
hiding rows 2
Help - hiding multiple sets of rows based on two different cells 2

Top