Print out tables

Uploaded time: November 5, 2021 Difficulty: Primary

Print out tables

Print out tables

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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 range area

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

_1.gif


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.

_2.gif


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.

_3.gif

 

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.

_4.gif

 

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.

_5.gif

 

· 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 edge or Flip on long edge.  

_6 (1).gif

 

· 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.

_7.gif

 

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.