How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed. 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. 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. Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column or multiple rows and columns.
