How to print a specific page in Excel?

sub has a stamp print ().

worksheets("sheet1").printout from:=1, to:=1, copies:=3, collate _

trueworksheets("sheet1").printout from:=3, to:=3, copies:=3, collate _

trueworksheets("sheet1").printout from:=12, to:=12, copies:=3, collate _

trueworksheets("sheet1").printout from:=28, to:=28, copies:=1, collate _

trueend sub

Add a button in the form to connect to the macro, OK, no seal printing can refer to the above processing!

If you want to print a specific page, you can click the mouse over that page and click Print the current page in Print.

Originally, your conditions are already very complicated, and there is only one way ——- make up a VBA macro to achieve it.

The Excel print sheet has a setting for each page that uses the print title function of the page layout.

1. Open the Excel document with content, select the Chinese file with the cursor, and double-click the left mouse button.

The result is: <>

2. Click "Page Layout".

3. Click "Print Title".

4. Place the cursor on the box to the right of the top title line (r) and click the left mouse button.

5. Click the symbol on the right side of the box in the top header line (r).

The result is: <>

6. Select the title line that you need to have on every page.

7. Click the "Enter key" on the keyboard.

8. Click "OK".

9. Click Print Preview to check whether there is a required title line on each page.

Get the results on the first page:

Get results on other pages:

Notes:If you strictly follow the above steps, the fourth step of the operation "put the cursor on the right side of the title line (r) at the top, click the left mouse button" can be canceled, the third step is followed by the fifth step, the fourth step is to be familiar with the operation after the hand guess directly in the box to fill in the title line cell personnel use, directly fill in the fifth step directly after the sixth step operation.

1. Select the area you want to print, and drag the box directly with the mouse.

2. After selecting, click the page layout, click the print area, and then click Set the print area.

3. Click on the view, and then click on the pagination preview, at this time you can see that the content is divided into two pages.

4. There is a dividing line in the middle of the search tape pagination, move the mouse to the dividing line, the mouse will become a two-way arrow, at this time, hold down the mouse, drag to any position you want, left and right.

5. You can drag it into a page, of course, if you have a lot of content and is cut into many pages, you can also drag it, and then it's OK.

In Excel, if there is a slender ** that needs to be printed in columns, it should be set in the printing options, and the steps are as follows:

Click "Print" - find "Mix and Scale" in the print options - Select the number of columns you want to divide into in "Editions per page" - Select "Left to Right" and "Top to Bottom" in "Print Order" - Confirm printing.

Slender **.

Print, "Hit and Scale" to select the number of editions per page.

Select Top to Bottom or Left to Right.

The end result. Click on "Print" - find "Punch and Scale" in the print options - Select the number of columns you want to divide into in "Number of plates per page" - Select "Left to Right" and "Top to Bottom" in "First Trace and Typing Order" - Confirm printing.

1. First of all, you need to open the excel**, as shown in the figure, you need to operate each page has a footer of the first page, click on the left rubber to light up the page layout in the upper corner, so that you can see that there is already a footer added below.

2. Then enter the footer you need to set first.

3. Finally, you can also stretch the footer a little longer, so that the text you need and the enter key, so that you can see that all the beams have been set wide.

If you have hundreds of pages in front of you, you have a problem with your ** design!!

I really don't know how to enter these hundreds of pages of data, how to find and locate it, and how to modify and maintain it!!

In fact, you only need 2 tables to control these hundreds of pages of data!!

1. The first table is the template sample table that you need to print on the diagram to show Yinshen.

2. The second table is to make a basic database list of all the contents of the first table in the way of a column. All management, maintenance, and modifications are done by managing this table.

Then, in the first table, use the formula to set the cells of all the contents with the formula, and when printing and displaying, as long as you make a unit or number selection, you can extract the data information of the whole page one by one.........

Then set the fixed ** as the footer, and set the signed lines to be fixed.

Take screenshots of the following two rows and three columns.

Page layout, page settings and suspicions, margins, and increase the following margins to a certain value (which can be adjusted according to the size of the screenshot). Header footer, click Customize footer. With the cursor in the middle of the footer, click the Insert icon.

Select From File, select Initial Screenshot, Insert. Are you sure.

I wrote that there are tools to do what you said.

Other data, is it the same on every page.

Excel** is printed out on just one page as follows:

Chiropractic conversion device: Dell Inspiron 7400

Operating system: win10

Operating software: excel**2017

1. Click File.

Click on the File option, as shown in the image below.

2. Point high impact printing.

Click the Print option in the left menu, as shown in the image below.

3. Click Zoom.

Click the Zoom drop-down menu in the settings menu, as shown in the image below.

4. Click Options.

Click the Adjust Worksheet to One Page option in the menu, as shown in the image below.

1. First of all, select Excel** in the computer, and double-click to hit Yinye Kai, as shown in the figure below.

2. Then in the interface, click the "File" button on the top left, as shown in the figure below.

3. Then in the interface, click on the "Print Preview" option in "Print".

4. Then in the interface, click the "Page Settings" button, as shown in the image below.

5. In this interface, modify the zoom ratio to 100%, and click the "Confirm Paragraph" button.

6. Finally, in this interface, the typesetting display is the same as the print preview (printing) effect display.

1.How to print multiple ** pagination in a worksheet in excel.

For example, if there are 4 ** in the workbook, I want to print one ** on each sheet of paper, and print it out on 4 sheets of paper.

Step 1: Enter the "View" tab, click "Page Preview" in the "Workbook View" option group;

Step 2: There are only 2 pages in the "Pagination Preview" in the above picture, which are "Page 1" and "Page 2" respectively. We move the cursor to the border in the lower right corner, when the mouse becomes a double arrow, hold down the left button, drag the border, and then release the mouse until we see "Page 3" and "Page 4";

Step 3: Now excel can print 4 pages out, but we also need to cut the above two ** to the bottom, and the cutting is completed as shown below:

Now that the pagination has been completed, if you print the workbook, you will print 4 sheets of paper, one on each piece of parchment paper**, and then talk about how to automatically pagination printing!

Automatic pagination page setup in excel:

1.Portrait Landscape Setting: Click the Page Layout tab, click Page Margins, select Custom Margins at the bottom, and select Portrait or Landscape in the pop-up Page Settings.

2.Page margin setting for pagination: Then go to "Margin" to set the margin size of upper, lower, left, and right margins;

3.So the header and footer settings of the page: You can also customize the page to set the header and footer as you like.

to quickly insert and remove page breaks.

First, position the light bumper to the position where you want to add pagination, then click Separator in the Page Layout tab, and select Insert Page Break or Delete Page Break. If you want to reset all the pagination effects, you can check "Reset all page breaks".