| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i protect a formula but not the whole page?
Sarah,
Another simple solution is to highlight the sheet, goto FORMAT in menu bar, select CELLS, then click on PROTECTION, click on LOCKED, and then click HIDE. Clicking on HIDE will hide all formulae on that sheet. Then click OK you can then click on TOOLS, OPTIONS, then VIEW and in the top row click off FORMULA BAR. This will remove the formula bar from the spread sheet. I hope this is of help Regards Art Caragh "SARAH" wrote: I want to protect the formula but not the whole page and all i seem to be able to do is protect the page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I protect the page setup? i.e. 45% landscape | Setting up and Configuration of Excel | |||
| Excel formula to change page # when data entered in other page | Excel Discussion (Misc queries) | |||
| I want to protect beyond the page break | Excel Discussion (Misc queries) | |||
| In Excel 2003 can you password protect a single page in excel? | Excel Worksheet Functions | |||
| protect format - page setup | Excel Discussion (Misc queries) | |||
Hybrid Mode
