Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
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. -- Regards, Fred "Daniel- Sydney" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
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 "Fred Smith" wrote: 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. -- Regards, Fred "Daniel- Sydney" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
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 Singapore http://savefile.com/projects/236895 xdemechanik --- "Daniel- Sydney" wrote: .. 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
Max
thanks for your help regards Daniel "Max" wrote in message ... 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 Singapore http://savefile.com/projects/236895 xdemechanik --- "Daniel- Sydney" wrote: .. 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
You're welcome, Daniel !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Daniel" <none@none wrote in message ... Max thanks for your help regards Daniel |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide cells
Daniel,
To hide a cell ~ go to format cell and choose CUSTOM under the number tab - then type in ;;; That's it! Diane "Daniel- Sydney" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
hide formulas but can edit on the same cells | Charts and Charting in Excel | |||
Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Active Hide Emtpy Cells | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions |