Excel, problem with hiding formulas.... please help!

[David]

Hi. I have a spreadsheet set up as a "game". you enter someting in a cell,
and the formula is taken from another cell elsewhere on the sheet. However,
i have somehow hidden or protected most of the sheet, the bits containing the
text, I cant work out how to alter it, its not under Tools Options, think its
something else...?
can e mail it if it helps?
David........

 

[CyberPhix]

To view Formula's the quick way is to use Ctrl+~
or go to Tools, options, on the view tab check Formula's
This will show you all the formula's along with text.

 

[Gord Dibben]

David

How about Tools>Protection>Unprotect Sheet.

OR hit CRTL + A(twice in xl2003) to select all. Right-click on a column
header and "unhide".

Gord Dibben Excel MVP