How to set excel table header

How to set the excel header: first open the excel table that needs to be set, and select [Click File-Page Settings]; then select the worksheet, click on the right side of the top title row; finally select what needs to be displayed on each page header and click OK.

The operating environment of this article: Windows 7 system, Microsoft Office PowerPoint 2020 version, Dell G3 computer.

How to set excel table header:

1. Open the excel table that needs to be set

2. Click File----Page Setup, select the worksheet, click on the right side of the top title row (red mark)

##3. Select the header you want to display on each page. After selecting the header, click the red mark on the right and click OK. Then check the header you set in the print preview.

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