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

The SUM function is commonly used when we process data with WPS Spreadsheet.Use the SUM function values in certain cells. Take this worksheet as an example. How can we sum the values in the yellow-filled cells? 1. Click the Insert Function button in the Formula tab.2. Insert the SUM function from the selection box.3. We can also click the SUM option in the AutoSum dropdown list in this step. Then, there will be a popup dialog titled Function Arguments, where Number means the range to r....

In the process of document typesetting, adding page numbers can help us quickly retrieve and locate. So, how can we insert the page number into a document? Take this document as an example. Click the Insert tab first, then click the Page Number drop-down button. In the Built-in Style, we can choose the style according to demand. If there is no suitable page style, we can click the Insert Page Number button to set up. In the pop-up Insert Page Number dialog box interface, we can set the....

Margins are the white space between the contents of the document and the edge of the page. When typesetting and printing, we can adjust the margins according to the content layout. Take this document as an example. Click the Margins button in the Page Layout tab. Then we can select some regular page margins in the selection list. If we want to customize the page margins, just click Custom Margins in the Margins selection list, then the Page Setup dialog box will pop up. We can also s....

When using WPS Writer, how can we customize the font for a document? In the toolbar of Home, users can simply set the Font, the Size, etc. For advanced settings for font, click the drop-down button next to Menu, choose Format and Font, then you can see the interface for Font setting. You can also press the shortcut Ctrl+D to pop up the dialog. In this interface, we can change the settings for Latin text font and Asian text font, which include fonts, Font style and Size. You can also c....

When we edit a document, we will inevitably need to enter some symbols that are not directly entered by the keyboard input method. So, how do we insert the special symbols that we need? Take this document as an example. We want to tick the tourist attractions we have visited to facilitate statistics. Click the position where we want to insert the symbol and click the Insert tab and the Symbol drop-down button. We can see Recently Used Symbols and Custom Symbols here. These are the ....

When we use the WPS Spreadsheet, we often need to merge and combine multiple cells. Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function. · Merge and CenterSelect the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M. In this way, the selected cells can be merged into one cell and displayed in the center. · Merge CellsSelect ....

The function of Tabs in WPS Writer allows us to adjust the position of the text when typing by setting the horizontal Ruler, in order to align the text and symbols. And, it could be also used in Microsoft Office Word and Openoffice. How can we use the function of Tabs? If the ruler is not displayed in the document, we can click the View tab and check Ruler. The number on the Ruler represents the number of characters, and the page width on the current page is 41 characters width. Take t....