In the use of Excel is often used in the cell freeze, the use of this feature makes reading the table more clearly, but also easy to analyze the data, the following is a description of the freezing function in Excel:
Small series recommended:
How Excel 2010 freezes windows
Excel2007 freeze window, fixed window in table
How Excel freezes Windows
As shown in the illustration above, a form that is not frozen can be used for this form with horizontal freezes and column freezes, so that the entire table's horizontal and column fields are fixed for easy access when scrolling.
If the data shown in the table above, if it is frozen horizontal, then directly select a horizontal, as shown above to select the first two horizontal freeze, and then click the window after the following image:
Then click on the Freeze window, the effect shown in the following figure,
Scrolling mouse can appear as shown above, if you want to freeze the horizontal and column, the following figure gray area shows how to do?
The results of the successful operation are shown in the following example, by selecting the black area first and then selecting the window in the menu bar (freezing window).
Classification: