Download WPS Office for your device

When working with tables, skillful use of shortcut keys can greatly improve our work efficiency.Today, we will learn some tips about the Alt shortcut key.· 1. Wrap text automaticallyTake the table as an example. The text of the title is too long. So, we need to wrap it. Select the cell and hold down Alt+Enter at the position where it needs to wrap.· 2. One-click AutoSumIf Weekly Total is required for each assembly line, select cell area J3:J13, and press Alt+= to sum with one click.· 3....

Graduation season is coming. Do you know how to create a professional resume for a job like this? Now we'll introduce you to how to create a resume in WPS Writer step by step. l Step 1. Set the page size.In this blank document, we need to set the page size and margin in advance. Click the Page Layout tab, select the common size of a resume, A4, and set Margins as the built-in Narrow.l Step 2. Arrange the overall layout with ShapesThe resume should be clean and concise with fewer f....

When we use WPS Presentation, in order to save time, we often use templates.Today, I will teach you two ways to quickly use the templates.1. We can save the beautiful slides we've made as templates, which can be shared with others or reused by ourselves. Take this slide as an example. We have edited it in advance using the Master Slides feature. If we need to save it as a template to share with others or use it again, just click Menu and click Save as.Select WPS Presentation Templa....

We may sometimes need to apply a pre-set slide master to the current page when editing a slide.Do you know how to make it? Take this slide as an example. Click Design and then click Edit Slide Master, and we can see there are three different slide masters. So how can we apply "a master with the WPS Academy logo" to the current page? First, click Design, and click Involved Template.In the pop-up dialog box, we can select the desired slide master. And we can also select Apply Current or....

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

When we use WPS Spreadsheet to organize the data form, we may sometimes need to add borders to the cells in the table. For example, we may use the upper and lower borders to make alphabets, employee information tables, music staff, and so on. Different data forms require different cell borders, so how can we to set the table border style? Take the employee information table as an example. 1. Select the cell area.2. Click the Home tab in the upper feature area and then the Other Borders....

WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....