How to display title on each page of excel table

php editor Xigua will introduce you in detail how to set the title to be displayed on each page in the Excel table. In Excel, you can set the title to be displayed on each page through simple operations, which makes it easier to read and view data. Next, we will explain the specific operation steps for you step by step so that you can easily master this technique.

1. The product list as shown in the picture needs to be printed now, and the same title should be printed at the top of each page.

　

2. Open the excel worksheet you want to print, switch to the "Page Layout" tab, and click "Print Title".

　

3. Pop up the page setup dialog box, switch to "Worksheet", there is a pick box to the right of "Print Title - Top Title Row", click it .

　

4. After selecting the title to be printed, click the pick box to exit.

　

5.Excel automatically adds the "Top Title Row", click OK.

　

6. The title bar will be automatically added. Click "Print Preview" and confirm that it is correct before printing.

　

As you can see, after the operation, the title bar of each page of the table is printed out, and the title description of each page of data is particularly clear and will not appear. In a chaotic situation, how to display the title on each page of an excel table must be mastered by staff who often engage in data statistics.

The above is the detailed content of How to display title on each page of excel table. For more information, please follow other related articles on the PHP Chinese website!