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.
For example, to freeze the top row and first column , select cell B2, go to the View tab and click Freeze Panes under Freeze Panes: In the same fashion, you can freeze as many Excel panes as you want. For instance, to lock the first 2 rows and 2 columns, you select cell C3; to fix 3 rows and 3 columns, select cell D4 etc. Naturally, the number of locked rows and columns does not necessarily have to be the same.