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.
Another option is to use three cells. Say B1 contains the default. This cell is locked. The user can enter a value in B2. Cell B3 is locked again, and this contains the formula =IF(B2=,B1,B2). If the user enters a value in B2, this is returned, otherwise the default value from B1 is returned.