In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables.

In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer.

If we need to print two copies of the spreadsheet document, we can check All in the Page rangearea

In the Number of copies box, choose 2 and click OK.

If we need to print multiple copies of the spreadsheet document, it is recommended to check Collate. Then, the documents are printed one by one so that we can organize and bind them easily.

In the Scale to paper size drop-down box, we can select the desired paper size and click to print.

Let me show you the print effect of A5.

In addition to the most basic printing methods, I will introduce you to several common printing methods.

· The first case

In order to save paper, multiple-page spreadsheet documents can be scaled to print on one page.

In the Pages per sheet box, select 2 Pages. In the Scale to paper size, select A4. In the Order area, choose From left to right. Then, the table will divide the A4 paper into two sections in left-to-right order.

We change 2 Pages to 4 Pages and check Draw line between pages. In the Scale to paper size, select A4. Then, the table will divide the A4 paper into four sections and display the segment line.

· The second case

Duplex printing is often used in the printing industry. Check Duplex to achieve the duplex printing effect. According to the different binding directions, we can choose Flip on short edgeor Flip on long edge.

· The third case

In some particular industries, there are special requirements for printable tables. We can check Inverse output to display the printed tables in a mirror style.

These are the problems and solutions about printing out tables. Did you get it?

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.