Excel2007 How to freeze a window

What are the Excel2007 freeze window methods? Many friends in the upgrade download Office2007 version of Office software do not know how to use Excel2007 freeze window. Here is a way to teach you, you can not have a friend to see.

Excel2007 freeze a row by freezing the window horizontally:

1, if you want to freeze a row, first need to select the line below it. To put it simply: if you need to freeze the "A2" line now, you must select the "A3" line (pictured below).

2, then go to the View tab, click Freeze pane in the Window option group, and choose Freeze split panes from the following menu!

After setting the freezing window, you can see that there is a horizontal line in the "A2". (pictured below)

Excel2007 freeze a row method for vertical freezing of a window:

Excel vertical The same method of freezing, this is skipped.

Excel2007 Freeze Horizontal, vertical (row, and column) methods while freezing a window:

I don't know if you've noticed, you can't fix "a row and a column" at the same time in the above methods, either freeze a row or freeze a column. Here's how to fix "a row and a column" at the same time.

How do you want to freeze "A2 rows" and "A1 columns" now, for example, in the following illustration?

1, click the mouse to select the B3 cell, and then click the View--> Freeze pane--> freeze the Splitter pane.

2, set the freezing window will appear after two black lines, which proves that the OK, the following figure.

The above is the method that Excel2007 freezes a window, different circumstance has different operation, everybody learns?