How to set the top header of multiple worksheets at once in Excel

You can't do it according to your method, there is still a solution to the problem, you just want to speed up the same settings, and you don't need to set them in the page setup at once.

Resolution. First, after setting the position of the top title in the first table, you can copy the characters in the text box, and then paste the page setup once for each table, which is also very fast.

Resolution. Second, the first table is set to thick, copy the whole ** out of the new table also has the same format as the first one, and then copy the required data to the new table.

Resolution. Third, it is set up with VB programming. Of course, that's more cumbersome, and you'll have to learn one more piece of software.

Select several worksheets at the same time, execute file - page setup - header footer - select "custom header", and then enter the header you need in it. You can adjust the position of the header by printing the preview, but you can't see the header in the state, which is a disadvantage.

Select all sheets, then set the top headers, and all headers will be the same.

If you require a header on each page, you can click Menu File - Page Setup to pop up the page setup dialog box, click Worksheet - Print Title - Select the top header row or the left header row to set it and confirm.

Here's how:

1. Open the document you want.

2. Click the "Start" menu - "Page Setup" button.

3. Find the "Worksheet" option.

4. Click the button in the top header of the worksheet, as shown below.

5. After entering, select the title row, and usually select the header and header.

The text of the first line.

6. Finally, click the "Preview" button, so that from the second page onwards, each page has a table header.

The idea is good, but unfortunately it is not feasible.

You can start by setting $1:$2 to print out the first 10 pages, and then change the top title line to $226:$227 to print the last 10 pages.

What about horizontal rows? For example, pages 1-10 are in columns A to K, and pages 11-20 are in columns L-Z.

Set the title that appears on each page when printing in Excel as follows:

1. Open the required excel**, select the [Page Layout] function, and then select [Print Title];

2. Click on the title setting box, select the [Top Title Line] in the print title to set it, and click the command character of the back arrow;

3. Jump to the page title settings, select the part of the title that needs to be printed, and then press "Enter" and click to confirm;

4. Finally, you can click on the print preview to check whether your settings are correct, or to check the effect of the settings between printing. How it works:

01 Start excel2010 first, execute the file-open command, open a copy of the data** 02

Click the Page Setup menu, and in the toolbar, click the Print Title Option button. 03

Switch to the Worksheet tab in the page setup dialog box that pops up. 04

Click the pick button at the right end of the top header row, then select the header row and click the pick button again to return. 05

Then click on the print preview below to see the effect, and switch to the second page to view. 06

When you get back, click the OK button so that the printed document has a header line on each page.