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.
Exercising this level of control in Excel requires you to do two things: 1) unlock the cells you wish to allow others to edit and 2) enable worksheet protection settings. To unlock cells, highlight the cells to be unlocked and then right-click and select Format Cells on the context-sensitive menu.On the Protection tab of the Format Cells dialog box, uncheck Locked, as shown in Figure 1. Note that, by default, Excel locks all cells on a worksheet.xercising this level of control in Excel requires you to do two things: 1) unlock the cells you wish to allow others to edit and 2) enable worksheet protection settings. To unlock cells, highlight the cells to be unlocked and then right-click and select Format Cells on the context-sensitive menu.