In Microsoft Excel, the Freeze Panes option keeps specific rows or columns visible while scrolling. It creates a separate worksheet area of visible from non-visible areas when scrolled.
An Excel pane is part of the window. The worksheet itself can be split into panes using the Split option. You can also freeze panes, so that one is on the screen all of the time. You also have the task pane, which is outside the worksheet, but can show other things, such as help options.
You can only have two panes if you use Freeze Panes. If you are using the Split option you can have up to 4 windows on your worksheet.
The question is not clear, but this is my best guess for an answer. There is no way to freeze only a single cell. Select cell B2 and freeze panes. In Excel 2007, on the View Tab, in the Windows section, click on Freeze Panes. Then, select the first option to freeze columns to the left and rows above the selected cell.
Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.Freeze panes.
Freeze Panes
You use the Freeze Panes option. When you do it, columns to the left of the active cell and rows above the active cell will be frozen. So if you wanted to freeze just the first column, you would make B1 the active cell before freezing the panes. To freeze just the first row, you would make A2 the active cell before freezing the panes. To freeze both the first column and first row, the you would make cell B2 the active cell before freezing the panes.
In Excel 2003 and earlier, place your cursor in row 2 and click on Freeze Panes. The Freeze Pains command will freeze the rows above the cursor. Excel 2007 offers an option to freeze top row no matter where your cursor is located.
You would make cell A6 the active cell and then activate the freeze panes option.
There is no shortcut key to do this, but you can press Alt + W + F + F in Excel 2007 to access menu options to toggle between freeze and unfreeze panes. (I do not remember if this same sequence works with Excel 2003; you might just have to press F one time in Excel 2003.)
Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.Click on cell B2. Then use the Freeze Panes option, which you will find in the Window menu or View ribbon, depending on your version of Excel.
Select cell A2. Then, on the menu bar, select Window, Freeze Panes.
Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.Use the Freeze Panes option. Put the cursor just under the header row and set the Freeze Panes option to be on, and then when you scroll down, the header rows will remain on the screen. You can also use the Split option, but this is not really for that purpose.