How Excel freezes panes use

Everyone in the use of office2010 Excel tables found that the table pane will scroll with the mouse, so that the following will be confused with the corresponding title, this time just the Excel pane freeze will not scroll with the mouse, Just freeze the Excel pane in the Settings window. Oh, the following and small set together to see how to operate it.

Office2010excel How to use the frozen panes:

1, freeze the first line, click the "view → freeze pane → frozen first line" menu item to complete the setup.

2, the top horizontal pane, select the next row of cells to be frozen, click the view → freeze pane → freeze splitter pane menu item. For example, if you select a cell in a red box, the cells in the yellow box will be frozen.

3, the left vertical pane, this one is mainly used for large table space, extended to the right, and want to see the contents of the right-hand side, see the first column of content, you need to choose to freeze the first column.

Select the column of cells to the right of where you want to freeze, and click the view → freeze panes → freeze splitter pane menu item. For example, if you select this column in the Red box, the column in the yellow box will be frozen.

4, at the same time the top horizontal and left vertical pane, this one is used more. Click the lower right cell where you want to freeze, and then click the view → freeze pane → freeze splitter pane menu item. For example, if you select a cell in a red box, the cells in the yellow box will be frozen.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join