Design on a Dime Host Gets XXXtreme Makeover. TMZ has finally uncovered the connection between the HGTV show Design on a Dime and hardcore pornography -- a host who really enjoys interiors.
Lock Cells. You can lock cells in Excel if you want to protect cells from being edited. In this example, we will lock cell A2. Before you start: by default, all cells are locked. However, locking cells has no effect until you protect the worksheet. So when you protect a worksheet, all your cells (=worksheet) will be locked.
This unlocks all the cells on the worksheet when you protect the worksheet. Now, you can choose the cells you specifically want to lock. On the worksheet, select just the cells that you want to lock. Bring up the Format Cells dialog box again (Ctrl+Shift+F). This time, on the Protection tab, select the Locked box and then click OK. On the Review tab, in the Changes group, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.