If you add column and row labels to your worksheet data, it just makes sense that you would want them to appear on screen at all times so it makes it easier to work with your data. It can be very tedious if you have to keep scrolling up and down to see what you are doing.
- To keep your row and column labels visible, you can freeze the rows and columns where your labels are located. You could, for instance, easily freeze the first three rows of your worksheet along with the first column. Then, when you scroll the worksheet the rows and columns will remain on the screen. Only the unfrozen part of the screen will scroll.
- You specify which rows and columns you want to freeze by selecting the cell immediately below and to the right of the area to be frozen.
- Then, to freeze the rows and columns you would select Freeze Panes from the Windows menu. In version 2007 you would display the View tab of the Ribbon and click Freeze Panes in the Window group and then click Freeze Panes again.
- MS Excel will place a thicker black line above and to the left of the current cell to indicate the rows and columns that are frozen in your worksheet.
- If you should decide that you no longer need frozen panes, you can simply select Unfreeze Panes from the Window menu.
- In version 2007, you display the View tab of the Ribbon and click Freeze Panes in the Window group and click Unfreeze Panes.