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.
How to start a slide show
After we use WPS Presentation to open the slide, click the Slide show tab. We can choose to start a slide show from whatever slide we want here. · From Beginning:· From Current Slide:By clicking the Play icon in the status bar below, we can start the slide show from the current slide quickly.We can also use the shortcut key F5 to start the slide show from the beginning and Shift+F5 to start from the current slide. This skill could be compatible with Microsoft Office powerpoint.
How to print a slide in WPS Presentation
First, use WPS Office to open the slide.Then click the Print button in the upper left corner or use the shortcut key Ctrl+P to use the print feature.In the Print pop-up box, we can adjust the settings according to our needs and then click OK. Note: We can click the Print Preview button on the upper left corner of the page to view the printout effect before printing.This skill could be compatible with Microsoft Office powerpoint.