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

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

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