Word and Excel table header sharing method Encyclopedia

1, first look at how to share the table in Excel header:

Divided into two kinds of cases, one is in the input in different table head at the same time, that exists real, the method is very simple, such as you are currently in SHEET1, you hold down the CTRL key while clicking SHEET2 then two tables are selected at the same time, you are in the current SHEET1 input, finished enter. You can see SHEET1 and SHEET2 's head is the same.

Another situation is that you don't have to input, but when you print out the headers for different pages are the same, in fact, there are two ways to achieve this, the first option is to click on the File menu page settings, switch to the tool table in the "print title" at the top of the header row select you want to share the printed table head ranks. The second approach is a bit extrapolate. Also in just this page Setup switch to "header footer" and then customize the header footer, hey is not the same effect?

If you only need to operate a little easier to see the table head sharing, also do not need to print out, in fact, Officeba told you there is a way to use, the "Window" menu "Freeze window", specifically said, we operate on the cicada. Ha.

　　2, and then see how Word shares the header.

This is more simple: Select to share the title, and then click on the Menu "table", select "header row repeat" can be achieved!

Table header sharing for everyone in the long page input is not more convenient and practical!