How to freeze rows in excel: How to lock cells in Excel to

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit. This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need. Then, by selecting a row below row 4 and scrolling up, you no longer see rows 5 through 9. Also, you don't see columns D through F. This brings a tight focus onto Q4 and the YTD totals in columns G and H. To undo a split, simply click View > Window > Split again.