How to set up Excel printing

Under Print Preview, select margins to make as many adjustments as you like.

Basic Settings for Printing Basic settings for printing 1, set the excel print range 2, set the number of pages to print 3, set the print paper 4, set the print margins 5, set to print all columns 6, set to print all rows 7, set to print the entire page.

After entering the data in excel, you need to print, the format of this printing can actually be set, many people may not know much, the following is how to set the printing format in excel shared by me, I hope it will be useful to you.

How to set the printing format in ExcelSet the print format Step 1: Open an excel file we need, compile some data casually, click on the file - print, you can see from the print preview on the right, the file we want to print will print 2 pages by default.

Figure 1 shows how to set the printing format in ExcelFormatting the PrintStep 2: In order to print the data into one page, we only need to make a simple setup.

Format PrintStep 3: Still in File - Print page, there is a No Zoom option in the last option of the settings.

Figure 2 of the method of setting the printing format in ExcelFormat PrintingStep 4: Click the drop-down arrow on the right side of this option to see many settings for printing, including no scaling, resize worksheet to one page, and resize all columns to one page, etc.

Figure 3 of the method of setting the printing format in ExcelStep 5: Since the ** in the example is too many lines, we can choose to adjust all the rows to one page, and we can see that in the print preview, the content that originally needed to be printed on two pages has become one page.

Figure 4 of the method of setting the printing format in ExcelFormat PrintingStep 6: If the worksheet is made with too many columns and needs to be printed with multiple pages, we can choose to adjust all columns to one page to adjust the number of pages printed.

Figure 5 of the method of setting the printing format in ExcelFormat PrintingStep 7: If there are too many columns and rows to increase the number of pages, we can choose to adjust the worksheet to one page to adjust the number of printed pages.

Figure 6 of the method of Excel to set the printing formatSet the printing format step 8 Summary: In Excel 2010, we can quickly set the printing format to adjust the number of printed pages according to our own printing requirements, which is convenient and fast.

You may also like:1excel how to print out the form of **.

2.How to print labels with excel.

3.A detailed explanation of the print settings of Excel 2013.

4.excel2007 how to set up the print page.

5.How to set up to print once in excel, the contents of the cell change once.

6.How to put excel**.

Adjust to the right size for printing.

7.How to set the print area in Excel.

1. Open the Excel file you want to print, press the shortcut key "CRTL+P" to bring up the print setting options.

2. In the common settings, you can set five options: "Control", "Vertical and Horizontal", "Paper Size", "Margin", and "Scale".

3. Click "Page Settings" to set more detailed parameters in the above options, if you need to print the header and footer, you can click the "Header Sail Noise Footer" tab.

The "Page" tab can set "Print Orientation", "Scale", "Paper Size", "Print Quality", etc.

The Margins tab allows you to customize the margins on the top, bottom, left, and right, and you can also set the centering method to <>

The "Worksheet" tab can set "Print Area", "Print Title", "Print Properties" and so on.

4. Click "Custom Header" and "Custom Footer" respectively, here the options of "Header" and "Footer" are exactly the same, the usage is basically the same, you can insert the text format, page number, page number, date, time, file path, file name, data table in the left, middle and right areas.

5. After all the settings are completed, you need to set up the printer at the end, and click the drop-down box below the printer.

Select the printing device and you're all set.

You can click Print in the Excel screen where you want to print, and then select the specified printer in the print options that appear. Here's how:

1. Open the excel file on your computer and click the file selection print button in the upper left corner.

2. In the print interface that appears, click the printer drop-down arrow to select the printer you want to use.

3. After selecting the specified printer, click the print button to start printing.

4. Wait for the printing to be completed to filial piety, and then you can see that you have used the designated printer to complete the printing work.

1. Let's open the blank excel.

2. Let's click "Print".

3. In the repentance of the beam, we can then set the number of pages to be printed.

4. Then we can also set the number of pages printed by the rubber blind brother.

5. Then we can also set the printing content.

6. We can then set up the printing paper.

7. We can also set the number of printing plates.

Open the excel file on your computer and enter the content you want to print in **. Click "File" in the upper left corner of the software and select "Print". Select the corresponding printer in the "Printer" option, here select "Foxit Reader PDF Printer", and click "Print".

Tools Raw Materials:

Lenovo G40-30

Microsoft Windows 7

excel2010

1. First of all, open the excel file in the computer and enter the content that needs to be printed in **.

2. Click "File" in the upper left corner of the software.

3. Select "Print".

4. Select the corresponding printer in the "Printer" option, select "Foxit Reader PDF Printer" here, and click "Print".

5. Pop up the prompt message that the content is being printed, and then pop up the dialog box to select the save location, enter the appropriate file name, and click "Save".

Step 1: Click Print, and the print dialog box will appear;

Of course, you can also set a printer as the default printer.

Not yet, don't do this useless work, you can choose a printer when you start menu printing.

Don't dot print directly.

Set the macro button, enter the macro, click to automatically select the non-default printer when printing, and restore the default printer after printing, and the other ** is still the default printer.

After we have finished making ** using excel, we need to print it. But there are many beginners who don't know how to use a printer to print**, today I will share with you the operation steps of "print excel directly", I hope to help beginners.

Operation steps: 1. We open the prepared excel, and we take the following figure as an example.

2. "File" button, and find Print in the drop-down menu and click it.

3. Then set and adjust in the new pop-up print window, if you don't need to adjust, you can click "OK" directly. At this time, if your computer is properly connected to the printer, then the printer will print your **.

The above is the operation steps of "directly printing excel" that I shared with you today, I hope you will gain something.

First, open Excel, select the area you want to print, find the [Page Layout] option at the top of the page, select [Print Area], and click [Set Print Area]; Then click the small arrow icon in the lower right corner, select the direction you need to print text in the dialog box after popping up, adjust the [Zoom] and [Page Width], [Page Height], select [Paper Size] and [Print Quality], and finally click [OK]; After closing this dialog box, click [File] - [Print] in turn, if there is no problem, click [Print] in the upper left corner;