Print center display
1 Click on the page layout to print the preview.
2 Find the page setup and select the margins in the page setup dialog box.
3 check the horizontal and vertical in the center mode, and it will be OK.
one page
Obviously, we only want to type one page, but there are always two more lines of data, which leads us to always type one more page. How to solve it?
1 Click Page Layout 1 Print Preview.
2. Click Page to set the page. 1. Adjust the worksheet to one page for printing.
Print title bar
Print a multi-page table with a header row, but every time you print it, you find that only the first page has a header row. Method:
1 Click the "Page Layout" option; Find "Print Title"
2 Select the top header row and the left header column in the print header.
3 After selecting the title area we need to print, click OK.
Print headers and footers
During printing, add page numbers or headers to the printed worksheet. At this time, you need to set it with the help of header/footer.
1 Click Page Layout 1 Print Preview.
2 Select the header/footer in the page setup dialog box.
3 Select the appropriate header and footer, and then click OK.
Monochrome printing
Some friends will fill cells with background color in order to highlight the key points of data, but office printers are generally black and white, and the printing effect is worrying. How can I get rid of the filled color printing?
1 Click Page Layout 1 Print Preview.
2 Find the page setup and select the worksheet in the page setup dialog box.
3 Find a monochrome print in print and check it, so the fill color of the cell will not be printed at this time.
Selected partial print area
Only the area to be printed is selected as the printing object, and it is not necessary to print the entire worksheet.
1 Click on the page layout to print the preview.
2 Find the page setup and select the worksheet.
3. Fill in some selected cells in the print area; Click OK to select the print area.
Wrong cell printing
Sometimes it is inevitable that there will be wrong values in the worksheet (such as #DIV/O! )。 How can I not display the error value so that I can fill it in more flexibly after printing?
1 Click Page Layout 1 Print Preview.
2 Find the page setup and select the worksheet in the page setup dialog box.
3 Find the wrong print cell, and select