Hide cells

[Guest]

Hi

I have Excel 2002, I have a spread sheet where I have helper cells where
calculations are made and these are accessed by cells in the main part of the
spreadsheet.
I want to hide these helper cells from view, when I select these cells and
go to
Window/Hide the whole spreadsheet dissapears.

What am I doing wrong, how do I hide these cell?

thanks and regards

 

[Fred Smith]

You can't hide just cells. Where would Excel put them?

You can hide columns or rows. Right click on the border, and choose Hide. If you
want to hide more than one column/row, select them first, then hide them.

 

[Guest]

Fred

I have seen spreadsheets where the contents of the cells that do the
calculation are hidden, without the cells being hidden. I guess that is what
I mean

cheers

 

[Guest]

Select the cols/cells, then click Format > Cells > Protection tab > Check
"Hidden" > OK. Then apply sheet protection: Tools > Protection > Protect
Sheet ... to hide the formulas in these cells.

 

[Daniel]

Max

thanks for your help

regards

Daniel

Select the cols/cells, then click Format > Cells > Protection tab > Check
"Hidden" > OK. Then apply sheet protection: Tools > Protection > Protect
Sheet ... to hide the formulas in these cells.

 

[Max]

You're welcome, Daniel !

 

[Guest]

Daniel,
To hide a cell ~ go to format cell and choose CUSTOM under the number tab
- then type in ;;;
That's it!

Diane