Today for everyone to gather to share some of the ways to form the first!
1, look at how to share Excel header:
Divided into two kinds of circumstances, one at the entry table in different table at the same time as the first, that is real, the method is very simple, such as your current SHEET1, you hold down the CTRL key while you click it SHEET2 2 At the same time, the selected table, you SHEET1 in the current input, after the completion of return. You can see the table SHEET1 and SHEET2 is the same as the first.
Another situation is not input, but different page printout of the table is the same as the first, the fact there are two ways to achieve, the first is under the File menu click Page Setup, switch to the tool table in the “Print the title of “choice of the top header line you want to share the first ranks of the table to print can be. The second way to judge the whole a bit mean. Also just set up this page to switch to the “header footer”, and then customize the header footer, hey is not the same effect?
If the only operation that can facilitate the sharing of the first watch, there was no need to print out, in fact, to tell you there are officeBA method can be used, by using the “Window” menu in the “frozen window”, specifically not to say, we operate about on the cicada. Kazakhstan.
2, then take a look at how to share the table the first word.
This is even more simple: to share the title selected, and then click menu “Table”, select “to repeat the header row” can be realized!
Table for everyone to share the first page of the long type is more convenient and practical it!
| Form regulation with the shortcut keys |
| IE plug-ins page with rapid import Excel spreadsheet software |
| Fix the size of table in Word |
| Copy the column width to retain the source of the Excel spreadsheet |