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.
Lock and protect formulas with Worksheet Design. If you have installed Kutools for Excel, you can lock and protect formulas quickly by using Worksheet Design utility. Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time. 1. Click Enterprise > Worksheet Design to enable the Design group. 2. Then click Highlight Formulas to highlight all formula cells. 3.Select all the highlighted cells and click Selection Lock to lock the formulas. And there is a dialog pops out to remind you that the fomulas cannot lock until protect the sheet. 4. Now click Protect Sheet to type the password to protect the sheet.