Download WPS Office for your device

By setting hyperlinks in the document, we can click them to quickly jump to the specified pages or web pages, making it more efficient and convenient for us to browse the document. Now, we can use the hyperlink function in PDF documents by joining WPS Premium. Take this thesis as an example. We need to add a corresponding hyperlink to the title in the catalog. Click the Edit tab and the Link drop-down button, select Add/Edit Link, then hold the mouse in the area where the hyperlink nee....

When we beautify the spreadsheet, we usually use the Fill Color function to color the cells in a spreadsheet before setting the typeface, font size for the text, etc. However, it is not efficient. Is there any better ways to realize it?1. Select the cell area that needs to be beautified.2. Click Cell Style in the Home tab. By doing so, a variety of predefined styles for cells has been provided by WPS Spreadsheet. Then we can choose one of the styles. If you don't like any of these....

Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....

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

When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

To ensure the beauty of the spreadsheet, sometimes we need to align the contents of it. How can we quickly set the alignment of the spreadsheet?This video could help to solve the problem of How to set the cell alignment in WPS Spreadsheet. There are several alignment shortcut buttons in the ribbon, which are commonly used in the workplace. Now let's demonstrate them one by one.Top Align: Align text to the top of the cell.Middle Align: Align text so that it is centered between the t....

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 we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....