excel2013 How to fix a table header

First, open the Excel document you want to fix the header, then select the row you want (note that you need to select the entire column);

Second, select the menu bar "View-frozen pane-Freeze Splitter Pane" can be;

Third, then you randomly sliding down the interface, you will find that the table head will be fixed, only the following data will move, the table head will not move;

Four, to unfreeze is also very simple, select the frozen header, and then select the View-Freeze pane-Splitter pane.