How to set up excel copy printing

What is set printing:

Set printing actually means printing vouchers and account books in advance , report format paper, a printing method for printing. This printing method eliminates the need to print table lines and other fixed format content when printing, which is helpful to speed up printing, save printing consumables, and extend the service life of the printer.

excel printing:

1. Scan the table

Scan the original table and set the scanning zoom ratio to 100. The mode is black and white text.

2. Set the background

Start Excel, click "Format/Worksheet/Background..." on the menu bar, open the worksheet background dialog box, and find the file you just saved The table image is set as the background. Try slowly adjusting the proportions so that it coincides with the background square.
3. Positioning filling
Adjust the row height or column width by dragging the boundaries of the row and column headers, and then use the "Merge and Center" button in the format toolbar to adjust the table lines Make it coincide with the table line of the background table (it doesn't have to be exact, as long as the text can be filled in at the desired position).
4. Page Setup
Click "File/Page Setup.../Page Margins" in the menu bar, and use a ruler to measure from the table border on the original form paper to the left and top of the paper. distance, directly enter the measured size into the corresponding left and top margins in the page setup dialog box. The right and bottom margins should be set smaller so that the entire table can be printed. Click the "Options" button to enter the printer settings interface to customize the paper size and directly enter the paper size. Of course, you also need to measure it directly with a ruler.
5. Print output
Now you can put the original form paper into the printer for printing. If the above operations are correct, it will generally be successful without adjustment. Even if there is a horizontal or vertical shift, just measure the offset value directly and then increase or decrease it to the corresponding top and left margins.
This method of printing tables in Excel is particularly suitable for printing a large number of related tables. The data in the three types of reports, such as financial, tax and statistical reports, are closely related.
Through the above introduction, in short, Excel copying is to scan the predetermined paper form, insert it in the background, and then remove the foreground content including the grid lines, and only enter data in the corresponding cells to achieve copying. beat.

Recommended: Excel Basic Tutorial

The above is the detailed content of How to set up excel copy printing. For more information, please follow other related articles on the PHP Chinese website!