Excel print title how to set each page has

How to set the excel print title on each page, the operation method is as follows.

1. First of all, open an excel** with good data in the computer. Click the Page Layout view on the menu bar, and click Print Title.

2. Click "Top Header Row" on the dialog box that opens, and select the header to be on each page.

3. Then click the print preview below to see the setting effect.

4. Finally, in the preview window that opens, scroll the mouse to see that a fixed header has been added to each page.

In Print**, set the "Top Header Row" and click on the first row of cells. After setting the cell range, click "OK". Click on the print preview, and you can see that each page of the print has a title, detailed steps:

1. Open the computer and click on the "Page Layout" above.

2. On the page layout page, click "Print Title".

3. In Print**, set the "Top Header Row" and click the first row cell.

4. After setting the cell area, click Print Preview, and you can see that each page has a title for printing.

1.In the toolbar above Excel, in the "Page Layout" tab, click "Print Title" at the bottom.

2.Enter $1:$1 in the text box behind the top header line (you can enter other lines as needed, set it as the title bar), and then click OK in the bottom right corner.

3.Back to Excel**, use the combination shortcut key Ctrl+P, and you can find that the Excel print settings show the title bar operation completed on each page in the print preview.

If you want to have your title in every heading, you can find the result you want in the settings.

Excel, printing ** every page is available, so you can set it directly, it is still very convenient.

First, click on the page layout, click on the print title, click on the top header row, and then select the title you want to print, and then you can complete the setup.

How to set up excel to have a title on each page when printing.

Page Layout Page Setup Print Title.

Top Header Row Select the line where the header is located or Consecutive Multiple Lines OK.

First, open the excel** program, select "Page Settings" at the top of the main interface of the program, click "Print Title", and click Zhaotong to open.

Second, then scrambled the number, find and select "Print Area" in the window dialog box, and click to open.

3. Then, in the "Print Title Line" position, slowly guess the first place to select the line you want to set the title.

4. Finally, you can see that each page has a title in the print preview, and the problem is solved.

If you want the header to be automatically displayed on each page when the excel sheet is printed, you can use Excel's "Print Header" function to do so

Edition: Page Layout - Print Title: After clicking the red arrow on the right side of the "Print Title" - at the top header line - select the header area of the table that needs to be displayed on each page (directly click on the row label to select - select the whole line), and if necessary, you can also set the "Left Header Column".

Version: File - Page Setup - Worksheet First Search: "Print Title" - Top Header Row After clicking the red arrow on the right side - select the header area that needs to be displayed on each page (directly click on the row label to select - select the whole row), if necessary, you can also set the "Left Header Column".