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

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........

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.


-----Original Message-----
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........
.

David

How about ToolsProtectionUnprotect Sheet.

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

Gord Dibben Excel MVP

On Thu, 4 Nov 2004 14:00:01 -0800, "David"
wrote:

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........