Freezing Columns or Rows in Microsoft Excel

Have you ever been in a situation where you have to scroll so far over to the left or so far down the rows that the label information is no longer visible? You can view two areas of a worksheet and lock rows or columns in one area by freezing panes. When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll through your worksheet. 1. To lock rows, select the row below where you want the split to appear. 2. To lock columns, select the column to right of where you want split to appear. 3. To lock both rows and columns, click the cell below and to right of where split will appear. 4. On the Window menu,click Freeze Panes. Now when you scroll through your gradebook
or worksheet, the columns will appear to slide under the frozen columns so you don't lose labels. 5. To unlock rows, click Unfreeze Panes on the Window. Still unsure of how this works. Watch a demo video on the Microsoft website at: http://office.microsoft.com/en-us/assistance/HA012001021033.aspx Written by Linda Beith, CCRI IT Instructional Support Team.