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.

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.

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.

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 Commentand set up Cell error as.

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.

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