hiding formula in cell


L

ljgent

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
 
Ad

Advertisements

J

Jim Thomlinson

Format -> Cells... | Protection Tab and Check Hidden. Now when you protect
the sheet the formula will not show.
 
Ad

Advertisements

L

ljgent

Hi Jim,
I have those boxes checked off, I did not protect the sheet and they do not
show?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top