Catalog

How to get excel for free in wps office (Easy Steps)

January 17, 2024 3.3K views

In the vast landscape of office software, WPS Office shines as an elegant all-in-one suite for PDF, Word, Excel, and PPT files, offering versatility and efficiency. As users seek distinctive and cost-effective solutions, the query arises - how to get Excel for free in WPS Office? This article brings you a one-of-a-kind guide, coupled with the exclusive WPS Spreadsheet download, to access Excel's features with unparalleled ease, without spending a penny.

WPS Spreadsheet


How to get excel for free in wps office

How to create a new excel document in wps

How to get excel for free in the WPS office? Follow these steps:

Step 1: Open WPS Office and go to "WPS Spreadsheets". Wondering where to download WPS Spreadsheet? Simply visit WPS Office

WPS Office Interface



Step 2: Go to "Menu" and select "New".

WPS Office New document



Step 3: Choose a Format.

WPS Office select format



Step 4: Fill it with relevant data, formulas, and formatting.

How to import a excel document in WPS

Follow these steps to import an Excel document into WPS Spreadsheets:

Step 1: Open WPS Office and go to "WPS Spreadsheets"

Step 2: Click on the Menu.

WPS Office menu



Step 3: Click on “Open” and choose the Excel document.

WPS Office Excel Document



Step 4: Click “Open” to begin using your excel sheet.

WPS Office import excel document



How to use excel document free app templates in WPS

Follow these steps to use free app templates in WPS Office:

Step 1: Open WPS Office on your system

Step 2: Click on “New” from the sidebar menu.

Step 3: Visit the Sidebar menu again and select “All”

Step 4: Using the Search Bar, search for your favorite templates or simply scroll down and choose one of the top templates suggested by WPS.

WPS Office template store



Step 5: Preview your template before finalizing and then download the template. Users can also add templates to their favorites list, a great way to make use of your favorite templates in the future.

WPS Office Preview and Download



Step 6: WPS Office also gives users the choice to save and share their personalized template with others for collaboration. Simply save your personalized template on Cloud. Others can then access WPS excel online from anywhere.

WPS Spreadsheet Templates



Microsoft Office compatibility in WPS

WPS Office offers compatibility with Microsoft Office file formats, allowing users to easily transition from Microsoft Office. WPS Spreadsheets can open.xls and.xlsx files without any hindrance. Furthermore, WPS Office allows cloud storage while preserving the formatting. This makes WPS Office a cost-effective and feature-rich alternative to typical office productivity software.

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

How to Edit excel document in WPS Office

WPS Office Spreadsheets have various editing tools, but here are the most popular ones.

How to use formulas in excel using WPS Office

Follow these steps:

Step 1: Open an Excel file with WPS Spreadsheets.

Step 2: Choose the formula's target cell.

Step 3: Click on “Formulas” from the top menu.

WPS Spreadsheet formula tab



Step 4: For calculations, use cell references and the operators. For sophisticated computations, use functions.

Step 5: Press enter to apply the formula.

How to add tables, charts to a excel document

Follow these steps to add tables in an Excel Document Using WPS Office:

Step 1: Open an Excel file with WPS Spreadsheets.

Step 2: Choose a data range for the table.

Step 3: Click on the "Insert" button in the top menu.

WPS Spreadsheet Insert tab



Step 4: Choose "Table"

WPS Spreadsheet insert table



Step 5: "Create Table" dialogue box appears.

WPS Spreadsheet create Table dialog box



Step 6: Check "My table has headers" and test the range if data has headers.

Step 7: Press “OK” to construct a table.

Step 8: Similarly to add a chart to your sheet, click on the "Chart" button and select a chart type.

WPS Spreadsheet insert chart



Step 9: Insert a chart with the default data.

WPS Spreadsheet chart options



Step 10: You can edit the chart by the "Chart Tools" button in the top menu.

WPS Spreadsheet edit chart



How to filter excel files in WPS Office using filters

Filters in WPS Spreadsheets make it easier to work with enormous datasets and extract essential information.

Follow these steps to use filters:

Step 1: Open an Excel file in WPS Spreadsheets.

Step 2: Click on the column header to select the column.

Step 3: Click on the "Data" button.

WPS Spreadsheet Data tab



Step 4: Select the "Filter" option

WPS Spreadsheet filter option



Step 5: Select the filter criterion (text, numeric, or date).

WPS Spreadsheet advanced filter dialog box



Step 6: Click "OK" to apply the filter.

How to use window freeze function in WPS Office in excel

WPS Spreadsheets' window freeze feature keeps critical headers or reference data visible, boosting usability and readability.

Follow these steps to Use Window Freeze Function:

Step 1: Open an Excel file with WPS Spreadsheets.

Step 2: Click a cell to choose it.

Step 3: Click on the “review” button from the menu

WPS Spreadsheet Review tab



Step 4: Click on "lock cell" button

WPS Spreadsheet lock cells



Step 5: Selected rows/columns become immobile.

Benefits of Using word document in WPS Office

WPS Office's numerous advantages make it an excellent alternative to Microsoft Office.

  • Freely available software: There are no subscriptions making it an affordable option.

  • User-Friendly Interface: A familiar layout allows an easy transition from other office suites.

  • Feature-rich: Powerful tools for creating professional-looking documents.

WPS Office features



  • Microsoft Word compatibility: Handling of.doc and.docx formats is seamless.

  • Spell check and language identification: For global users.

  • Document Templates: Pre-configured templates to save time.

  • Integration with the cloud: Access and collaborate on documents from anywhere.

  • Regular Updates: Active maintenance assures dependability and the addition of new features.

  • Support and services: Good customer support to sort issues.

Download WPS Office Now

Users can obtain several benefits by downloading WPS Office. Its lightweight form enables for fast downloads, reducing waiting time. The software's seamless document exchange and creation capabilities make activities simple and pleasant. WPS Office streamlines document management by providing a user-friendly interface and strong capabilities, making it a breeze to handle.

How to get excel for free in WPS Office? Follow these steps first to download and install WPS Office:

Step 1: Navigate to the WPS Office website

Step 2: Select the "Download" button on the website's homepage.

WPS Office download button



Step 3: Find the downloaded installation file on your computer. To start the installation process double-click on it.

WPS Office installation



Step 4: Follow the on-screen directions to complete installation and launch it WPS Office.

FAQs about excel file in wps office

Q1. How do I unlock an Excel spreadsheet in WPS?

To unlock an Excel worksheet in WPS Office, open WPS Spreadsheets and Excel files. Select "Review" from the top menu. Choose "Protect Sheet." Enter your password and then click "OK." You can now edit the Excel spreadsheet.

Q2. Is WPS Office different from Microsoft Word?

Yes, WPS Office is different from Microsoft Word, although it serves as a functional alternative to it. WPS Office is an all in one office productivity suite that includes WPS Writer. While Microsoft Word only offers word processing features.

Q3. How to save an excel document to google drive?

Navigate to Google Drive. Click "New" and then choose "File Upload." Select an Excel file from your PC. To upload the file to Google Drive, click the "Open" button. The Excel document will be available in your Google Drive account.

Elevate Productivity with WPS Office - Your All-in-One Office-Suite Solution

WPS Office offers a comprehensive suite with PDF, Word, Excel, and PPT features, providing users with seamless compatibility with Microsoft Office file formats. With a seamless transition to Microsoft Office file formats, users can access Excel for free in WPS Office without any hindrance. Experience the convenience of WPS Office and download it now to boost productivity and streamline your tasks with ease.


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