Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David
 
Posts: n/a
Default 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........
  #2   Report Post  
CyberPhix
 
Posts: n/a
Default

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

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
How to make Excel run limited number of formulas on a given worksh John Excel Discussion (Misc queries) 0 January 12th 05 05:29 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 05:23 PM
Excel problem with web based spreadsheets Steve Williams Excel Discussion (Misc queries) 0 January 12th 05 03:11 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"