How to search and use templates in WPS Office
After we open WPS Office, find + in the top tab bar and click it.Select the file type according to our needs. We will take this document in WPS Writer as an example here. It is also the same in WPS Presentation and WPS Spreadsheet.Select Document, then enter the keywords of the template we want to find in the search box to search.After finding the template we want, click Use Now to apply it to the document.To be office specialists, you could learn how to use WPS Office online in WPS Ac....
How to use Resume Master in WPS Office
After we open WPS Office, find Resume Master in the navigation bar on the left. Click the Resume Master button. Then find the red button Create My Resume Now on the new page. After clicking, we will come to the information filling interface. Users can fill in the information they need in their resumes here. Then Resume Master will help users automatically generate their resumes. At the same time, users can also preview their resumes in the Preview and Edit window on the right side of t....
How to use flash fill to quickly fill in data
Use WPS Office to open the table and select the cell need to be operated.Place the mouse cursor at the lower right corner of the cell, when the cursor turn into a cross, click and drag down to select all the cells that we want to fill data.Then click the icon appeared in the lower right corner, then select Flash Fill in the drop-down menu (or use shortcut key Ctrl+E).Note: Flash Fill can provide a filling rule that best meets the users' needs by comparing the relationship between s....
How to use the filter feature in WPS Spreadsheet
1. After we open the spreadsheet in WPS Office, click the Home tab, and click the AutoFilter button in the upper menu bar.2. Now click the drop-down button to filter according to our needs.3. After we click OK, we can view the filter results below.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to quickly number rows in WPS Spreadsheet
After we open the spreadsheet in WPS, enter 1 in the first cell you want to number. Place the mouse cursor on the lower right corner of the next cell. When we see that the mouse cursor turns into a plus icon, just click and hold to drag down the cursor to automatically number rows according to our needs.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to set borders for cells in WPS Spreadsheet
After we use WPS Office to open the spreadsheet, select the cells that need to add borders to.Then just click the All Borders button in the Home tab. By this, we can apply borders to the currently selected cells.If we want to adjust the settings of the borders, we can click the drop down button of All Borders. Then we can select the border style according to our needs in the drop-down menu.We can even click More Borders to customize borders in the popup box. Then click OK to apply the ....
How to insert a GIF into slides in WPS Presentation
1. After we open a slide in WPS Presentation, we first click select the slide we want to insert a GIF into. 2. Then click the Insert tab, and click the Picture button.3. Now select the GIF we want to insert in this popup window and click the OK button below.4. We can click the slide show from current button in the status bar below, and then we can view the GIF in our presentation.This skill could be compatible with Microsoft Office powerpoint.
How to set the slide transitions in WPS Presentation
After using WPS Office to open the slide, select the slide we want to add transition first. Then we can select a type of transition according to our needs in the Transitions tab. We can also preview the transition effect by clicking the Preview tab.This skill could be compatible with Microsoft Office powerpoint.