How to rename a worksheet
After we use WPS Office to open the spreadsheet, find the sheet tab below, and double-click the name of the worksheet.At this time, the name of the worksheet will be selected, and then we can directly enter the new name here.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to change my default PDF file to WPS Office
1. Right-click the file on our computer and select Open With → Select Choose another app.2. Check Always use this app to open .pdf files.To be office specialists, you could learn how to use WPS Office online in WPS Academy.
How to highlight duplicates in a worksheet
1. Open the spreadsheet with WPS Spreadsheet. 2. Select a range of cells for operation. 3. Click the Data tab → Highlight Duplicates → Set…4. Click OK in the popup “Highlight Duplicates” dialog. WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables, and more. Includes advanced animation, slide transitions, and support for video, images, audio, and even Flash.
How to add a watermark to slides
Users can’t add watermark directly to slides in WPS Presentation at the moment. But we can try to add a watermark through the text box.1. Use WPS Office to open the slides.2. Click the Insert tab → and then click the Text Box button. Now enter the content of the watermark in the inserted text box.3. Then adjust the text box’s settings according to our needs, such as size, position, font size and color.This skilll could be compatible with Microsoft Office powerpoint.
Remove animation of slide show
How can we remove animation of certain object with WPS Presentation? Follow these steps. Taking the text box filled with “WPS” as an example. To remove the animation, follow the next few steps. 1. Click the Animation tab → the Customize Animation button. Then the “Customize Animation” window will show in the right, with a list of all animations in the current slide. 2. Select the WPS text box, and we can see the dropdown button(s) in the “Customize Animation” window turning into orange....
How to set a picture as the background
After we use WPS Office to open the slide, click the Design tab, and then click the Background button. We can find the Insert the picture drop-down button in the popup window on the right side. Then select File. We can choose the picture according to our needs here, and click the OK button to apply the picture in the slide.This skill could be compatible with Microsoft Office powerpoint.
How to lock columns and rows in a table
1. Use WPS Office to open the table.2. Click the Review tab → and then click the Lock Cell button.3. Now click the Protect Sheet button, then the Protect Sheet box will pop up. Uncheck Insert Columns and Insert Rows.4. Now we will find it impossible to insert rows and columns in this table.This skill could be also used in Microsoft Office Excel and Openoffice.
How to Search for Content in PDF
1. Open the PDF file with WPS Office. 2. Get into the Home tab → choose Search (Shortcut key: Ctrl + F) 3. Enter the content that we want to find in PDF4. Then, the corresponding text contents will be highlighted in the document. * Tips: We can customize the finding settings by check/uncheck the options in the Search Pane window. With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process & edit pdf documents on Windows, Mac, PC, and Android pl....