Instruction of page setup in worksheet

Uploaded time: September 27, 2021 Difficulty: Primary

Instruction of page setup in worksheet

Instruction of page setup in worksheet

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

Quality

Auto 720p

Graphic skills

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful,  we can set up the printed page of the table.

 

Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box.01.gif

 

If we want to print too much data, we can print them on several pages. Except for the first page, all other data tables are printed without header rows or header columns. In the Rows to repeat at top box, we can enter the header row that needs to be printed fixedly. Click the Print Preview button below to preview the print effect.

As we can see, all the pages now contain the header rows.02.gif

 

Similarly, if we want the table to include column rows on every printed page, enter the Page Setup dialog box, then enter the column row that needs to be printed in the Columns to repeat at left box. Click the Print Preview button below to preview the setting effect.03.gif

 

If we need to print Gridlines, Row and column headings, etc., we can check the corresponding options in the Print area. We can also choose whether to print Comment and set up Cell error as.04.gif

 

In addition, in the page order area, we can choose Down, then over or Over, then down. After setting up the worksheet, we can click the Print Preview button to preview the printing effect in advance.05.gif

 

Make your work easier with WPS Spreadsheet like Microsoft Excel. Did you get it?