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.
On the Protection tab, clear the Locked check box, and then click OK. Note This unlocks all the cells on the worksheet when you protect the worksheet. In the worksheet, select just the cells that you want to lock.On the Home tab, in the Font group, click the Format Cell Font dialog box launcher. On the Protection tab, select the Locked check box, and then click OK.ock cells in a worksheet. When people work in your worksheet, they may accidentally wipe out formulas or change things you donât want changed, like titles or cell formatting. To prevent that, you can lock them out of certain cells and then protect the worksheet.