| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding formula in cell
I created a multi page spreadsheet and on each page I have the same heading.
On sheet two, three etc. I entered the following in the same cell ='BOY''S BOTTOMS'!D5 So when you put the information in the first sheet it will automatically fill in on all the other sheets. This is my problem I did something so that the formula does not show in the cell on all the other sheets but I forgot what I did. I need to create a different type of workbook and want to do the same thing hide the formula but like I said I can not remember. Does anyone have any clues? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding formula in cell
Format - Cells... | Protection Tab and Check Hidden. Now when you protect
the sheet the formula will not show. -- HTH... Jim Thomlinson "ljgent" wrote: I created a multi page spreadsheet and on each page I have the same heading. On sheet two, three etc. I entered the following in the same cell ='BOY''S BOTTOMS'!D5 So when you put the information in the first sheet it will automatically fill in on all the other sheets. This is my problem I did something so that the formula does not show in the cell on all the other sheets but I forgot what I did. I need to create a different type of workbook and want to do the same thing hide the formula but like I said I can not remember. Does anyone have any clues? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hiding formula in cell
Hi Jim,
I have those boxes checked off, I did not protect the sheet and they do not show? "ljgent" wrote: I created a multi page spreadsheet and on each page I have the same heading. On sheet two, three etc. I entered the following in the same cell ='BOY''S BOTTOMS'!D5 So when you put the information in the first sheet it will automatically fill in on all the other sheets. This is my problem I did something so that the formula does not show in the cell on all the other sheets but I forgot what I did. I need to create a different type of workbook and want to do the same thing hide the formula but like I said I can not remember. Does anyone have any clues? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding the error caused by the formula in a cell / column | Excel Discussion (Misc queries) | |||
| Hiding the results of a formula generated from a blank cell | Excel Discussion (Misc queries) | |||
| hiding the cell and the formula bar | Excel Discussion (Misc queries) | |||
| Hiding the value of a formula if 1 cell has a value of zero. | Excel Discussion (Misc queries) | |||
| Hiding formula but allow changes | Excel Discussion (Misc queries) | |||
Hybrid Mode
