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.
In Excel 2013 and resent versions, you can use F2 and F4 to speed things up when you want to toggle the lock. About the keys: F2 - With a cell selected, it places the cell in formula edit mode. F4 - Toggles the cell reference lock (the $ signs). Example scenario with 'A4'. Pressing F4 will convert 'A4' into '$A$4' Pressing F4 again converts '$A$4' into 'A$4'