1235 results for wps office compatible with microsoft office
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1235 results for wps office compatible with microsoft office
Hyperlink in WPS Office Spreadsheet
02:22Hyperlink in WPS Office Spreadsheet
When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....
Set the page printing area in WPS Office Spreadsheet
00:47Set the page printing area in WPS Office Spreadsheet
What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....
Make an animated card with templates in WPS Office PowerPoint
In this tutorial, you are going to learn the skills of how to make an animated card with templates in WPS Presentation. You don’t have to worry about the design skills because WPS Presentation provides you with diverse templates of card! Now we are going to take a Valentine’s Day card as an example. There are mainly three steps:1. Choose a template for your animated card.2. Animate the elements of your card.3. Save your animated card and share it.We’ll talk about these steps in the fol....
How to save ppt as pdf with notes in WPS Office
Welcome to WPS Official Academy to check the contents of how to save ppt as pdf with notes in WPS Office. It only takes you 3 minutes to read this free tutorial and then master this easy yet requisite trick.Speaker notes help a lot when the speaker attempts to present a fluent and attractive lecture. And sometimes we may need to save these slides as pdf with notes. How can we achieve this?l Steps to save ppt as pdf with notes in WPS Office1. Open your ppt in WPS Office.2. Head to the T....
How to analyze trends with sparklines in WPS Office Excel
Welcome to WPS Official Academy to check the contents of how to analyze trends in excel. You are sure to master the ability of analyzing trends after reading this tutorial! We can use a Sparkline to visualize the trend of a set of data. Let's have a try step by step.Here we take a set of sales data as an example. Suppose we want to know and analyze the sales trends of Beijing and Shanghai. 1. Head to the Insert tab, click the Line button to pop up a dialog. 2. Set the Data Range to....
Create formula with structured references in WPS Office Excel
Welcome to WPS Official Academy to check the contents of how to create formula with structured references in WPS Office Excel. · Explicit reference & Structured reference in WPS SpreadsheetBefore learning how to use structured reference, it’s best to know what it is and why it is used first. Here we introduce another concept Explicit reference for comparison.1. What is Explicit ReferenceExplicit Reference is mostly used in our daily work. When you input the specific cell range like C2:....
Explanation on WPS Presentation printing interface
03:30Explanation on WPS Presentation printing interface
When using WPS Office to print various files, we often encounter different small problems. This video will briefly explain the function of each small feature of the printing interface, and it could be compatible with Microsoft Office powerpoint. If you want to learn more printing skills, you can search printing in our WPS Academy to enjoy more related videos. Take this slide as an example. First, we need to determine that the printer hardware can work properly and is now running. We al....
How to convert PPT to PDF with hyperlinks in WPS Office on mac
Sometimes when you need to save a presentation as a PDF file, some hyperlinks and notes may be lost. To avoid this problem, you can convert ppt to pdf with hyperlinks in WPS Office. Steps to convert ppt to pdf with hyperlinks in WPS Office:1. Open your ppt file in the WPS Office. 2. To save it as .pdf format, go to Menu and click Export to PDF, or go to the Tools tab and click Export to PDF to pop up the dialog box.3. Choose the ppt file and click Export to PDF. After completing the a....