How do I freeze Excel table rows and columns?

Sometimes our Excel tables have very many rows and columns of data, so when you move to the bottom of the data, the table head can not see, if the number of columns, once the right to move, the left of the serial number and see, so very inconvenient, there is no way to put the table head and serial number fixed it, of course, We can use the Excel Freeze pane feature to achieve this.

The Excel table freezes specific methods as follows:

Method One, Frozen pane method

Position the cursor on the next line of the header row (which can be one or more lines) that you want to freeze, and then select window → freeze pane in the menu bar.

In this way, when scrolling around the screen, the frozen header row or serial number is always displayed on the top or the left, greatly enhancing the visibility of table editing.

If you do not want to fix the header and serial number, you can click on the menu "Unfreeze pane" on it, home said that in some machines or Excel version of the Freeze pane will fail, then use the following method to determine is achievable, it is to split the table, you can also implement the Excel table freeze.

Method Two, table split method

Position the cursor on the next line of the header row (which can be one or more lines) that you want to freeze, and then select Window → split in the menu bar.

This can also achieve the Excel table freezing function, this is to split the Excel table into two tables, data independent, the same function also enhances the intuitive table editing.

If you do not want to fix the header and serial number, you can click "Cancel Split" on the menu to cancel the Excel form freeze.

Of course, the above two methods interface is still a little bit different, the second method has a thicker box the first method is not, but a black side, the specific difference or let you go to practice it.