New to excel!! I want to ask how to set the title and end to every page

This can all be done in the page setup.

Page Setup Worksheet Top Title Bar, select the number of rows you want for each page, you can press and hold the line number to drag down.

There is no way to do it below, only through the header and footer method to solve it. Select the custom footer on the header and footer page, type **, fax, supplier, etc., adjust the spacing, and confirm.

Here's how I do it: set the title as the header, and set the end as the footer, which is the only way I've found so far, but I can only set the text title, not the **title... That is to say, you can't show the name, model, **、、、 and the like**form on every page, as the landlord said.

Which master knows how to point, I also want to learn a trick... Hehe.

1. Open the [Page Layout] tab on the menu bar.

2. Click "Print Title" in the page setup section

3. Open the page settings, there are the top title row and the left title column in the print title, and select the top title line.

4. Click on the small picture on the right and select the title line of the first page.

5. After confirmation, return to the page settings and click the OK button.

6. Open the print browsing in Print again. Hitchhike.

1. Open the [Page Layout] tab on the menu bar.

2. Click "Print Title" in the page setup section

3. Open the page settings, there are the top header row and the left header column in the print title, select the top header line.

4. Click the small icon on the right and select the title line on the first page.

5. After confirmation, return to the page settings and click the OK button.

6. Open the print browsing in Print again.

Tool Raw material: excel2007

Method Steps:

1. Select the page layout and click Print Title.

2. Select the worksheet in the page setup interface and click the icon on the right side of the header row at the top.

3. The following selection area interface appears.

4. Then select the title you want to print, and then click the icon on the right.

5. Click OK on the page settings interface.

6. After completion, click Print Preview, and see that the title line appears at the top of both pages, and the page setup is completed.

Software version: office2007

Here's how:1Click Print Title in Page Layout:

2.Select the title you want to print in the top header row, and then click OK:

3.In this way, each page will have a title when it is printed:

1. Open the ** you want to set, click "File", and click "Page Settings" in the pop-up menu.

2. In the pop-up Page Setup window, click Worksheet.

3. Click on the blank space of the header row at the top.

4. Select the header that needs to be displayed (for example, if you want to display the first row, use the mouse to directly select the first row), and after selecting, the selected range will be displayed after the "top header row".

5. Click "OK" in "Page Settings", the settings are successful, and you can view the effect of the settings through "Preview".

Do so in turn.

1, Page layout--- print the header ---worksheet--- top header row (select the whole row where the header is located) - OK.

Do you want to have a title on every page when you print, or do you want to scroll down and follow the title on top when you look at it? To print the title, you need to click on "Page Layout" and then click on "Print Title" to set the title area you want. If it's convenient to scroll down, you can select the title you want to see, click "View", and click "Freeze Window".

First, select the title, select Print Title in the page layout, and then print it directly.

Hello, do you want to automatically print the title on each page when printing?

I'm using version 10, so I'll take a screenshot of it!

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.

1.Open Excel2013

2.Find Layout Configuration - Layout Settings in the menu.

3.Select the small triangle in the layout settings.

4.Go to the layout settings window and find the footer of the page.

5.Select a custom footer.

6.The input refers to the choice after the eggplant.

7.Select Print Preview.

8.You can view the set footer.

9.The header setting is the same as the footer setting.

Click on the "File > Page Settings" in the menu, and then select the "Worksheet" selection card in the pop-up form, there will be a print title setting in it, and then position the corresponding Nakamori top title line for the range of the first title and the range at the bottom of the page to be sold. Hope it helps.

Press Ctrl+P, then Alt+W, click on Page Settings, click on the icon to the right of the top header, and select the title row (i.e. the title you said). Click on the Orange Banner on the right side of the top title, and select the title line (that is, the last page you said). Then you look at the preview.

I'm using the 07 version, which may not be quite the same as the 03 version, you just need to find the page settings, and the first relatives will answer it.

Try it by freezing the window.