Catalog

How to Format an Excel Spreadsheet for Printing in WPS Office

November 15, 2023 1.0K views

Unlock the power of professional document preparation with our step-by-step guide on formatting Excel spreadsheets for printing in WPS Office. Dive into the world of meticulous formatting and ensure your data shines on paper. Let's embark on this journey to transform your digital data into polished, print-ready perfection.

Where Is the Page Layout in WPS Spreadsheet?

WPS Spreadsheet Page Layout


Windows & Mac

Step 1: Open WPS Office Spreadsheet.

Open new WPS Spreadsheet



Step 2: Click on the "Page Layout" tab located in the top menu, typically found between the "Formulas" and "Data" tabs. This tab is where you'll find various page layout functions, including options for page setup, margins, orientation, and more.

Select Page Layout


The Page Layout tab contains a variety of tools for formatting the layout of your spreadsheet, including:

  • Margins: Set the margins for the top, bottom, left, and right sides of the page.

  • Orientation: Choose between portrait (vertical) and landscape (horizontal) orientation.

  • Page Size: Select a standard page size, such as A4 or Letter, or create a custom page size.

  • Headers and Footers: Add text, images, or page numbers to the top and bottom of each page.

  • Print Area: Specify which range of cells you want to print.

  • Workbook Views: Switch between different views of your spreadsheet, such as Normal, Page Layout, and Print Preview.

Page Layout features



Android

Android Logo



To access the Page Layout options on Android, tap the three dots in the top right corner of the WPS Spreadsheet app and select "Page Layout".

The Page Layout options on Android include:

  • Margins: Set the margins for the top, bottom, left, and right sides of the page.

  • Orientation: Choose between portrait (vertical) and landscape (horizontal) orientation.

  • Page Size: Select a standard page size, such as A4 or Letter.

  • Scale to Fit: Scale the spreadsheet to fit on one page.

  • Print Area: Specify which range of cells you want to print.

iPhone & iPad

Apple logo



To access the Page Layout options on iPhone and iPad, tap the three dots in the top right corner of the WPS Spreadsheet app and select "Settings". Then, tap "Page Layout".

The Page Layout options on iPhone and iPad include:

  • Margins: Set the margins for the top, bottom, left, and right sides of the page.

  • Orientation: Choose between portrait (vertical) and landscape (horizontal) orientation.

  • Page Size: Select a standard page size, such as A4 or Letter.

  • Scale to Fit: Scale the spreadsheet to fit on one page.

  • Print Area: Specify which range of cells you want to print.

How to Format an Excel Spreadsheet for Printing in WPS Office

Here’s the step-by-step guide on how to format an Excel spreadsheet for printing in WPS Office:

Step 1: Open the Excel spreadsheet that you want to print.

Step 2: Click the Page Layout tab in the ribbon bar.

Select Page Layout tab


Step 3: In the Page Setup group, set the Orientation, Page Size, and Margins.

Select to custom page


Step 4: (Optional) To print only a certain range of cells, click the Print Area button and then select the range of cells that you want to print.

Select Set Print Area button


Step 5: To preview how the spreadsheet will look when printed, click the Print Preview button.

Select Print Preview button


Step 6: Once you are satisfied with the print preview, click the Print button in the top left corner of the WPS Spreadsheet window.

Tips:

  • To print gridlines, go to the Page Layout tab and click the Gridlines check box in the Sheet Options group.

  • To print headers and footers, go to the Page Layout tab and click the Headers and Footers button in the Page Setup group.

  • To scale the spreadsheet to fit on one page, go to the Page Layout tab and click the Scale to Fit button in the Zoom group.

How to Select an Area for Printing in WPS Spreadsheet

To select an area for printing in the WPS Spreadsheet (in short), follow the steps below:

Step 1: Open the spreadsheet and go to the Page Layout tab.

Select Page Layout tab


Step 2: Click the Print Area drop-down button and select Set Print Area.

Go to Set Print Area


Step 3: Select the range of cells that you want to print.

Step 4: Click anywhere outside of the selected range.

Step 5: Click the Print Preview button to preview the print area.

Select Print Preview


Step 6: Click the Print button to print the spreadsheet.

Tips:

  • To clear the print area, click the Print Area drop-down button and select Clear Print Area.

  • To print multiple print areas, hold down the Ctrl key while selecting the print areas.

  • To print a specific table or range of tables, select the table(s) that you want to print and then click the **

How to Print the Entire Excel Spreadsheet on One Page

To Print the Entire Excel Spreadsheet on One Page

Step 1: Click the Page Layout tab.

Step 2: Click the Fit Sheet on One Page button.

Select Fit Sheet on One Page


Step 3: Click the Print Preview button.

Preview Print button


Step 4: Make sure the entire spreadsheet is visible on the preview page.

Step 5: Click the Print button.

logo

Note

 It is important to note that the Fit Sheet on One Page button may not work perfectly in all cases. For example, if the spreadsheet is very wide, the button may not be able to scale the spreadsheet down enough to fit on one page. In this case, you may need to manually adjust the margins or scale the spreadsheet yourself.

Overall, the process of printing an entire Excel spreadsheet on one page in WPS Office is well-designed and easy to follow.


Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs

1.What format does WPS Office use for Excel?

WPS Office uses the following formats for Excel:

  • XLSX: This is the default format for Excel spreadsheets in WPS Office. It is a compressed XML format that is compatible with Microsoft Excel 2007 and later.

  • XLS: This is the older Excel format that was used in Microsoft Excel 2003 and earlier. It is still supported by WPS Office, but it is recommended to use the XLSX format instead.

  • XLSM: This is a macro-enabled Excel format. It allows you to add macros to your spreadsheets to automate tasks.

  • ET: This is a template format for Excel spreadsheets. It allows you to save a spreadsheet as a template so that you can easily create new spreadsheets based on the template.

In addition to these Excel formats, WPS Office also supports a variety of other file formats, including CSV, PDF, and TXT.

2.Can I convert Excel Spreadsheet to PDF in WPS Office?

Yes, you can convert an Excel spreadsheet to a PDF in WPS Office. Here's how you can do it:

Step 1: Open your Excel spreadsheet in WPS Office.

Step 2: Go to the "File" menu at the top left corner of the window.

Step 3: Select "Save As" or "Export" from the dropdown menu.

Select Save As button


Step 4: Choose the location where you want to save the PDF and provide a name for the file.

Step 5: In the "Save as type" or "Format" dropdown menu, select "PDF."

Save as PDF Format


Step 6: Click the "Save" or "Export" button.

3.How can I adjust the page margins for my Excel spreadsheet in WPS Office to ensure it prints correctly?

To adjust the page margins in WPS Office for your Excel spreadsheet, follow these steps:

Step 1: Open your Excel spreadsheet in WPS Office.

Step 2: Navigate to the "Page Layout" tab.

Enter Page Layout tab


Step 3: Click on the "Margins" option. You can select predefined margin settings like Normal, Wide, or Narrow, or you can choose "Custom Margins" to set your specific margin values.

Custom on Margins tab


Step 4: In the "Custom Margins" dialog box, specify the top, bottom, left, and right margins according to your preferences.

Select to Custom Margins


Step 5: Click "OK" to apply the margin settings to your spreadsheet.


Summary

This article provides a step-by-step guide for formatting Excel spreadsheets for printing in WPS Office. It covers Windows, Mac, Android, and iOS, explaining how to adjust page layout, select print areas, and print the entire sheet on one page.

The article highlights WPS Office's user-friendly features and offers FAQs, including details on supported Excel formats and converting to PDF, making it a valuable resource for optimizing Excel printing in WPS Office.



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