lock and protect all but certain cells

**JediMaster** · 07-31-2010, 07:52 PM

Hi All

I would like to lock and hide all the formulas and most blank cells but leaving some cells open for input of data is there a way I can basically select all and or highlight the selected cells for input then invert selection then lock n hide then protect?? if so how

Many thanks In Advance

**martindwilson** · 07-31-2010, 09:17 PM

select all
then format /cells/protection
uncheck locked
then select range and/or individual cell that you want protected and do the same
but this time select locked /then protect sheet. you will have options what to protect but i dont know what they are in 2010

**JediMaster** · 08-01-2010, 03:11 PM

yes Im running 2010 but would also like it compatible with 2003 as 2003 is the version that the values will be added can it be done and if so how?

**martindwilson** · 08-01-2010, 03:52 PM

save it in compatibility mode first then apply the protection

**JediMaster** · 08-01-2010, 06:04 PM

thanks Martin works a treat

**JSM** · 08-20-2010, 09:52 AM

I have tried this method on my Macbook Pro using Excel 2008 and my entire sheet gets protected. Don't know if I should start a new thread but this one seems pretty close - "I am trying to lock only cells with formulas and have seen many posts with the steps that are supposed to accomplish this. (Format>Cells>Unlock - GoTo>Special>Select Formulas - Format>Cells>Locked - Tools>Protect Sheet) This works but protects my entire sheet. I just want to prevent other users from deleting formulas but free to enter data on the rest of the cells. I have a MacBook Pro using Excel 2008. Please help."