WPS Office is one of the most popular office suites for Androidwhich allows you to work with documents .docx, tables .xlsx and presentations .pptx directly on your smartphone. Unlike competitors like Microsoft 365 or Google Docs, the application combines free functionality with advanced tools available by subscription. But how can you use it most effectively? In this guide, we'll look at everything: from installation to hidden tricks that will speed up your work.
Many people mistakenly believe that full-fledged work with office files is possible only on a PC. In fact WPS Office on Android supports 98% of the functions of the desktop versionincluding editing formulas in Excel, slide animation in PowerPoint and even working with macros (in the premium version). At the same time, the interface is adapted for touch control, and cloud synchronization allows you not to lose data when switching between devices.
Installation and first launch of WPS Office on Android
Download WPS Office available for free from Google Play or the official website of the developer. The application weighs about 100โ150 MB depending on the version, but after installation you will need to additionally download language packs and fonts (more 50โ80 MB). Important: if your device has little memory, select the โLightโ option (WPS Office Lite), which takes up 2 times less space.
After installation:
- ๐ฑ Open the application and allow access to storage (necessary for working with files).
- ๐ Register via Google, Facebook or email (without registration there will be restrictions on cloud storage).
- โ๏ธ Select a folder for automatic synchronization (by default -
WPS Cloud, but you can connect Google Drive or Dropbox). - โ๏ธ In the settings (
โฎ โ Settings) enable "Auto-save" (every 5 minutes) and "Night mode" for comfortable work in the dark.
โ ๏ธ Attention: At the first start, WPS Office may request access to contacts and location. These permissions are not required for operation - they can be disabled in the settings. Android (Settings โ Applications โ WPS Office โ Permissions).
WPS Office interface: what is where
Home screen WPS Office divided into 4 tabs:
- ๐ "Documents" โ list of recent files and storage folders.
- ๐ "Cloud" โaccess to WPS Cloud (1 GB free) and connected services (Google Drive, OneDrive).
- ๐ฑ "Local" โ files saved on the device.
- โญ "Templates" โready-made forms for resumes, reports, presentations (many are paid).
To create a new file, click + in the lower right corner and select the type:
Document (analog Word), Table (Excel), Presentation (PowerPoint) or PDF. For quick access to tools, use the panel at the bottom of the screen - it adapts to the file type. For example, in tables buttons for adding formulas will appear there, and in Documents text styles.
| Tab | Purpose | Hot keys (if a keyboard is connected) |
|---|---|---|
| Documents | Last opened files | Ctrl + O (open) |
| Cloud | Files in WPS Cloud and other services | Ctrl + S (save to the cloud) |
| Local | Files on the device | Ctrl + N (create new) |
| Templates | Ready forms for quickly creating documents | โ |
If you often work with one and the same files, pin them to the main screen: long press on the file โ โPinโ. This will save time on searching.
Editing documents: from formatting to formulas
WPS Office supports all basic functions Microsoft Word, including:
- ๐ Text formatting: changing font, size, color, alignment.
- ๐ Inserting objects: tables, images, figures, charts.
- ๐ข Numbering and lists: automatic bullets and multi-level lists.
- ๐ Headers and footers: setting for printing or exporting to
PDF.
For working with formulas (for example, in a coursework or report):
- Click
Insert โ Equation. - Select a template (fraction, integral, sum, etc.) or enter a formula manually using LaTeX.
- To edit, double-tap the formula.
โ ๏ธ Attention: In the free version WPS Office some fonts (for exampleMathType) may not display correctly. If the formulas โshiftโ when opening on a PC, export the document toFile โ Export.
โ๏ธ Preparing the document for printing
Working with tables: formulas, graphs and pivot tables
The table editor in WPS Office is almost as good as Microsoft Excel. There are:
- ๐ 200+ functions: from
SUMtoVLOOKUP. - ๐จ Conditional formatting: color scales, histograms in cells.
- ๐ Pivot tables: grouping data by criteria.
- ๐ Sheet protection: Restrict editing for individual cells.
To insert a formula:
- Select the cell where the result should be.
- Press
=on the keyboard or thefxbutton on the toolbar. - Select a function from the list (for example,
SUM) and specify a range of cells (for example,A1:A10). - Click
โto confirm.
To create graph:
- Select the data range (including column headers).
- Click
Insert โ Chart. - Select a type (histogram, pie, linear, etc.).
- Edit the design through the menu
Designer.
How to import data from Google Sheets?
Open the file in Google Sheets โ File โ Export โ Microsoft Excel (.xlsx) โ Save to your device โ Open in WPS Office.
Presentations: animation, transitions and export to PDF
Creating a presentation in WPS Office on Android is easier than it seems. The application supports:
- ๐ญ Animation of objects: appearance, disappearance, movement.
- โก๏ธ Transitions between slides: change with the effect of "fade", "shift", etc.
- ๐ค Speaker mode: notes and timer on the smartphone screen (not visible to the audience when connected to the projector).
- ๐ฑ Gesture control: swipe left/right to switch slides.
To add animation:
- Select an object (text, image, shape).
- Tap
Animationon the toolbar. - Select an effect (for example,
Appearance) and adjust the speed.
For export to PDF (so that the presentation cannot be changed):
- Click
File โ Export โ PDF. - Select quality (
StandardorHigh). - Specify whether to include speaker notes.
Use the Laser Pointer mode in presentations: during a presentation, touch and hold the screen and a red dot will appear to highlight objects.
Cloud storage and synchronization between devices
WPS Office offers 1 GB free cloud storage (WPS Cloud), but it can be expanded up to 20 GBby completing simple tasks (for example, inviting friends). To connect other services:
- Open the tab
Cloud. - Click
+ Add account. - Select a service (Google Drive, Dropbox, OneDrive or Box).
- Log in and allow access.
For automatic synchronization:
- Open
Settings โ Cloud. - Enable the option
Auto-sync. - Select folders that need to be synchronized (for example,
Working documents).
โ ๏ธ Attention: If you edit the same file on several devices, WPS Office may create conflicting versions. To avoid data loss, use the function Lock file (available in the premium version) or coordinate changes with colleagues.
Hidden features and settings for advanced users
Many people do not know that WPS Office there are functions that simplify your work:
- ๐ Text search with replacement:
โฎ โ Find(regular expressions are supported in the premium version). - ๐ฑ Reading mode: removes all toolbars, leaving only text (convenient for checking documents).
- ๐ Version history: allows you to roll back to the previous revision of the file (available when synchronizing with WPS Cloud).
- ๐จ๏ธ Virtual printer: export to
PDFvia the print menu (โฎ โ Print โ Save as PDF).
For speed up:
- Disable interface animations in
Settings โ General โ Interface animation. - Enable
One-handed mode(in settings) if you have a large smartphone. - Use Voice input for text: press the microphone icon on the keyboard and dictate.
If you need to quickly insert frequently used text (for example, the header of a document), create quick phrases in the keyboard settings Gboard or SwiftKey.
Solving common problems
Even in such a proven application as WPS Office sometimes crashes occur. Here's how to fix them:
| Problem | Cause | Solution |
|---|---|---|
| File cannot be opened | Damaged or incompatible format | Try opening on PC and saving in another format (for example, .docx instead .doc) |
| Changes are not saved | No access to memory or cloud | Check permissions in settings Android and free space on the device |
| Slow operation | Too many open files or background processes | Close unnecessary tabs and clear the cache in Settings โ About โ Clear cache |
| Synchronization does not work | Problems with the Internet or servers WPS | Restart the application and check the network connection |
If WPS Office constantly closes or crashes:
- Update the application to the latest version.
- Clear cache and data in settings Android (
Settings โ Applications โ WPS Office โ Storage). - Check if it does not conflict with other office applications (for example, Microsoft 365).
โ ๏ธ Attention: If after the update Android WPS Office stopped opening files, try rolling back to the previous version of the application. To do this, download APK from the official website (section "Versions Archive").
FAQ: Frequently asked questions about WPS Office on Android
Can I use WPS Office without the Internet?
Yes, all basic functions (creating, editing, saving files) work offline only for synchronizing with the cloud, collaboration or downloading templates.
How. transfer files from Microsoft Office to WPS?
Open the file in Microsoft Word/Excel on your PC, save it in .docx/.xlsxformat, then upload it to WPS Office via the cloud or local storage. Formatting is preserved in 99% of cases.
How much does the premium version of WPS Office cost?
The subscription cost depends on the region. On average:
- ๐ฑ Mobile version: ~
300โ500 โฝ/monthor ~2000 โฝ/year. - ๐ป Cross-platform: ~
4000 โฝ/year(includes PC, Mac, mobile devices).
The free version is enough for basic tasks, but the premium gives access to macros, extended fonts and cloud 20 GB.
Is it possible to edit PDF in WPS Office?
Yes, but with limitations. In the free version you can view and comment PDF, as well as fill out forms. To fully edit text and images, you need a premium version.
How to recover a deleted file in WPS Office?
If the file was deleted from WPS Cloud, check folder Trash (stores files for 30 days). For local files, use data recovery applications (for example, DiskDigger), but the chances depend on how much time has passed since deletion.