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.
Step 1: Unlock the Data Entry Cells. By default, all the cells on the worksheet will be locked, if you protect the worksheet. To allow changes to some cells, you have to change the protection setting for those cells. On the worksheet that youâre going to protect, select the cells that users will be able to change â cells A2:C6 in this example. On the keyboard, press Ctrl + 1 to open the Format Cells dialog box. On the Protection tab, remove the check mark from Locked. Click OK, to close the dialog box.