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.
Click the row number located just under the last row you want to lock. Excel only allows you to lock the top rows of a spreadsheet, so everything above your selected row will become locked in place. 3. Click the View tab at the top of the screen. Click the Freeze Panes button in the Window area of the ribbon. Click the Freeze Panes button that then appears in a pop-up menu. 4. Select the column letter or row number that corresponds to the information you want to alphabetize.