I want to make parts of my worksheet unavailable to users so that they can not click in the cell, change formats of the cell(s), etc..

Excel Help tells me that the only way to do this is if I am SHARING the workbook but this is not that kind of thing. It’s not on a network and it’s not a multi-user workbook.

How do I protect (for example) A1:A10 yet leave everything around it open for data-entry?

PS: I am working with Excel 2007, but I also need this information for my 2003 files that I use on another computer as well.

Any help would be appreciated!!

.

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I want to make parts of my worksheet unavailable to users so that they can not click in the cell, change formats of the cell(s), etc..

Excel Help tells me that the only way to do this is if I am SHARING the workbook but this is not that kind of thing. It’s not on a network and it’s not a multi-user workbook.

How do I protect (for example) A1:A10 yet leave everything around it open for data-entry?

PS: I am working with Excel 2007, but I also need this information for my 2003 files that I use on another computer as well.

Any help would be appreciated!!

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software

I’m working on a formula for an excel spreadsheet and I need help solving for a single variable in a three variable formula. This should be easy, right?

80x+3xt=2w

I need to solve for x for the formula to work in excel. Help?

Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software