Download WPS Office for your device

In the process of using WPS Office, we can set the overall view effect of WPS components for personal use. Take the components in WPS Writer as an example. Click Menu and choose Options. At this time, a dialog box will pop up. In the left tab, the first one is View. In this interface, we can set Show, Print, options, Formatting marks and Ribbon options. +In the Show box, we can set Status bar, Mini Toolbar. +In the Print options box, we can set the content that needs to be displayed. F....

When we use WPS Office to print documents, we often encounter a variety of printing glitches. So in this video, we are going to briefly explain the effects of each small function in the print panel. Let's take this thesis as an example. First, we need to make sure that the hardware device of the printer is normal and on-state. Meanwhile, we also need to determine whether the computer used can find your printing device in LAN. 1. Click Menu and Print. The Print dialog box also can b....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Hyperlinks in the text can jump to the webpage or the specified position in the document. Today, we will learn how to add hyperlinks. · 1. Jump to to a location on the webFirst, place your cursor on where the hyperlink needs to be added, and enter the Insert tab, click Hyperlink to generate a dialogue box. Head to Existing File or Web Page on the....

When using WPS Presentation, we can set the view effect according to our personal preferences and habits.Click Menu and choose Options.In the popup dialog, click View.In this interface, we can set up Show, Thumbnail and outline position, Slide show and Ribbon options. In the Show area, we can check the elements that need to be displayed, such as Startup task window, Status bar, Vertical ruler and so on. Then, click OK to change the view settings. In addition, we can also check Show Min....

You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....

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....

Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.First of all, insert a total column on the right of the table,select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in thi....

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....