Lock a Range of Cells in Excel

Prashant asks today's question: Please tell me the way for locking only a particular range of cells along with the formula instead of locking the entire sheet.

First you have to unlock all the other cells. This is a non-intuitive first step, but it is necessary, because all of the cells start with their "Locked" property set to True.

1) Select the entire sheet by clicking on the grey square to the left of the gray letter A at the top of column A
2) From the menu, Format > Cells. Click the Protection tab. Uncheck the Locked checkbox. Click OK.

Then, you can protect a certain number of cells. For this example, let's protect F4:G10.

3) Select cells F4:G10.
4) From the menu, Format > Cells. Click the Protection tab. Check the Locked checkbox. Click OK.
5) From the menu, Tools > Protection > Protect Sheet. Enter a password if so desired.

Now, only the cells in F4:G10 will be protected.

Lose weight with Excel

Are you trying to lose weight? I ran across a great paper-based system by Ron Martin and helped Ron to perfect it in a nice Excel utility called the Weight Loss Boss.

I've lost 10 pounds since I started using it 3 weeks ago. Through a special arrangement with Ron, I am selling the Weight Loss Boss and an e-copy of his book, "Success Made Easy". Check them out!

w-Life Coupler for Excel

It is said that more than 80% of the global supply chain needs XML technologies to become efficient, but they do not have money to buy them because of the high price tag associated with these technologies.

Check out e-Life Coupler. All this makes Coupler the ideal solution for today’s business world. Coupler is a real XML technology that solves real business problems in a very cost effective way.