How to Print an Excel Spreadsheet with Lines in WPS Office (Step-by-Step)

January 18, 2024 799 views

When working with spreadsheets, maintaining the gridlines is essential for readability and organization. However, it can be frustrating when these lines vanish during the printing process or when you convert your sheet to a PDF in various office applications. Fortunately,

WPS Office offers a simple solution to this issue offering you a step-by-step on how to maintain the lines in your Excel spreadsheet when using WPS Office.

How to Print an Excel Spreadsheet with Lines in WPS Office

How to Set Print Area in WPS Spreadsheet?

At times, you may need to print only specific cells in your spreadsheet. In this section, we will explore a feature in WPS Spreadsheet that allows us to selectively set the print area for the cells of our choice.

Step 1: Open WPS Spreadsheet and access the spreadsheet file you intend to print.

Step 2: Select the specific cells you wish to print, and then navigate to the "Page Layout" tab.

WPS Office Page Layout tab

Step 3: Click on "Print Area" and choose "Set Print Area." Your selected cells will now be designated as the print area.

WPS Office Set Print Area

Step 4: To ensure everything is set as desired, you can always go to "Print Preview" in the Page Layout tab and confirm that the selected cells have been correctly established as the print area.

WPS Office Print Preview

How to Show or Hide Gridlines in WPS Spreadsheet?

Before we proceed with learning how to print an Excel spreadsheet with gridlines in WPS Office, let's first explore how to Show or Hide Gridlines in WPS Spreadsheet:

Step 1: In WPS Spreadsheet, click on the "View" tab.

Step 2: In the view ribbon menu, to display gridlines, ensure the "Gridlines" checkbox is selected. To hide gridlines, simply uncheck the checkbox.

WPS Office gridlines

This is the simplest method for displaying or concealing gridlines in your Excel spreadsheet within WPS Spreadsheet.

How to Print a Worksheet with Gridlines in WPS Spreadsheet?

Printing a worksheet with gridlines in WPS Spreadsheet is a straightforward process, but sometimes users forget to enable the "Print with Gridlines" option before printing. Here's a step-by-step guide:

Step 1: Open WPS Spreadsheet and navigate to the "Page Layout" tab.

Step 2: In the "Page Layout" ribbon, click on "Print Preview" to check if gridlines are visible.

WPS Office Print Preview to check gridlines

Step 3: If gridlines are not visible, simply exit the print preview by pressing the "Esc" button on your keyboard. Then, check the "Print Gridlines" checkbox.

WPS Office Print Preview Gridlines

Step 4: Once you've checked the "Print Gridlines" checkbox, click on "Print Preview" again. You will now see the gridlines displayed in your print preview.

WPS Office print gridlines

These simple steps provide a comprehensive guide to printing Excel with gridlines in WPS Office, where simplicity is key!

Why Choose WPS Spreadsheet for Data Editing and Analyzing?

Microsoft Office now faces fierce competition in the world of spreadsheet tools. With the advent of WPS Spreadsheet, users are presented with an exceptionally robust and user-friendly alternative.

WPS Office

Here's why choosing WPS Spreadsheet for your data editing and analysis needs is a smart decision:

  • Cost-Effective Solution: WPS Spreadsheet offers an affordable alternative to Microsoft Excel without compromising on essential features. This cost-effectiveness is particularly appealing for individuals and businesses looking to manage their budgets efficiently.

  • Compatibility: Whether you're working on a Windows PC or a Mac, WPS Spreadsheet ensures cross-platform compatibility, enabling you to access your data seamlessly from various devices.

  • Collaborative Tools: Collaboration is made easy with WPS Spreadsheet, as it enables real-time co-editing and sharing capabilities. Team members can work simultaneously on the same document, enhancing productivity and teamwork.

  • Templates for Efficiency: WPS Spreadsheet offers a collection of ready-to-use templates that cater to a variety of needs, from simple budgeting to complex data analysis. These templates provide a head start for your projects and help you maintain consistency in your work.

  • WPS AI: With the integration of cutting-edge AI functionalities in WPS Spreadsheet, WPS Office has achieved unprecedented heights in empowering users to efficiently process and analyze intricate data sets through its AI assistant. For seamless assistance in chart creation, users can confidently rely on WPS AI Assistant to recommend the most suitable chart for visualizing their data. With WPS AI, every aspect of data visualization becomes a significantly enhanced and efficient experience, marking a substantial leap forward in user productivity.

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
Algirdas Jasaitis


Q1. How to print gridlines in Microsoft Excel?

Step 1: Open WPS Spreadsheet and go to the "Page Layout" tab.

Step 2: In the "Sheets" section, under Gridlines, you will find checkboxes for "View" and "Print". Check the "Print" checkbox.

Microsoft Excel print gridlines

Step 3: Now, go to the print preview, and you can verify that the gridlines are visible.

Q2. How to set page layout in WPS Office on mobile?

To set the page layout in WPS Office Mobile, follow these steps:

Step 1: Open WPS Office Mobile on your device and access a document.

Step 2: After opening the document, tap on the menu icon located at the bottom left.

Step 3: Navigate to the "View" tab and scroll down. Towards the bottom, you will find the option "Set Mobile View Default". Toggle this option to turn it on.

WPS Office Mobile View option

Q3. How do I convert a worksheet into a PDF in WPS Spreadsheet?

Step 1: Open your worksheet in WPS Spreadsheet. Then, go to the "Tools" tab and click on the "Export to PDF" option in the ribbon menu.

WPS Office Tools tab

Step 2: In the "Export to PDF" window, specify the destination for the PDF. Afterward, click on "Export to PDF" to convert the spreadsheet into a PDF file.

WPS Office Export to PDF

Printing Gridlines with Precision in WPS Office

Gridlines played a crucial role in data presentation, enhancing the overall look and readability of your spreadsheet. Preserving these lines was essential. We explored an effective method on how to print an Excel spreadsheet with lines in WPS Office to ensure that your sheet retained its gridlines, making your data not only accurate but also visually appealing. To get started, download WPS Office and discover the power of seamless data management and presentation.

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