Choose the 'Unfreeze Panes' option. Freezing Panes in Excel 2007. Select the row just below the one you want to freeze by clicking on the row header. This will make a specific row or rows visible as you scroll within Excel. Spyware doctor license name and code. Select the 'View' tab in the 'Windows' group, and choose 'Freeze Panes.' Select 'Freeze Panes' from the pop-up list to keep rows visible while your worksheet scrolls. In Excel for Mac 2011 Essential Training, author Curt Frye gives a comprehensive overview of Excel, the full-featured spreadsheet software from Microsoft. The course covers key skills such as manipulating workbook and cell data, using functions, automating actions, printing worksheets, and collaborating with others. How to Freeze Panes in Excel 2008: This is a really simple article describing how to fix a particular Excel problem with “freezing panes” (maintaining visibility on the first one or more rows and/or columns). Actually, you can freeze panes without splitting the screen first. Just click on a cell then click on Window > Freeze panes. This will freeze the cells to the left of and above that cell. In the screen shown in your example, B4 would be the cell to click on first.

1. How To Freeze Panes In Microsoft Excel

If your data set is large and it is difficult to see which values correspond to what heading, you can “lock” the first column or the top row in place while you scroll. To do this, go to the View Ribbon, click on the Freeze Panes icon in the Window Group, and choose either Freeze Top Row or Freeze First Column (you would have to do this one at a time if you wanted to freeze them both).

How To Freeze Panes In Microsoft Excel

Once you freeze the panes, you need to unfreeze them to either adjust them or add another pane. To remove the pane(s), go back to the Freeze Panes icon in the Window Group, and and you will now see the option Unfreeze Pane. If you click the Split icon (View Ribbon > Window Group), it will add a horizontal and vertical split in your document that you can adjust, and then freeze.

You can also drag the panes into position: 1. At the top of the vertical scroll bar, there is a thick bar. Move your cursor over this bar and it changes to two parallel lines with an arrow. Click and drag to divide the window vertically into panes. Adjust the split so that the first row (or two) is the only row in the top pane. To set a horizontal pane, use the similar thick bar at the lower right corner of the scroll bar and drag it to the left.