WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Instructions of page setup in worksheet

Uploaded time: September 27, 2021 Difficulty Beginner

Instructions of page setup in worksheet

Instructions of page setup in worksheet

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.

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 Commentand 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?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.