Download WPS Office for your device
Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

Download WPS Office for All Platforms
Find your device and get the right version
- Choose your platform
- Download WPS
- Install and launch
Search Results
465 results for how to remove hyperlink in excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
465 results for how to remove hyperlink in excel
How to add hyperlink to PDF
01:42How to add hyperlink to PDF
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....
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....
Smart use of Hyperlink in WPS Writer
01:49Smart use of Hyperlink in WPS Writer
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....
More features in Remove Duplicates
03:14More features in Remove Duplicates
To remove the duplicate data when dealing with tabular data, we can use the function of Remove Duplicates. In Microsoft, we can select the needed cell range and click the Remove Duplicates button in the Data tab to remove them. In WPS Spreadsheets, in addition to removing duplicates, we can also mark them for further review and collation.1. Click the Data tab, click the Highlight Duplicates drop-down button, and select Set. 2. Then select the cell range that needs to be marked and clic....
Remove image background in WPS Writer
00:55Remove image background in WPS Writer
If we find that the background color of a picture is different from the page color when editing a document, we can remove the picture's background color with one click. First, we can click the picture to enter the Picture Tools tab.Click the Set Transparent Color button, and click the background color of the picture to remove it. Tips: In addition to removing background color, we can also change the picture's color in this way.In general, we can not freely change the color of a....
How can we add or remove text shading
01:20How can we add or remove text shading
When using WPS Writer to edit documents, we can add shading to highlight some parts of the text content. So how can we add and remove text shading? Take this document as an example. If we want to highlight the students mentioned in the notice, we can select this part of the content and click the Character Shading command button in the Home tab. By this, we can quickly add a gray shading to the selected content. Gray is the default color. If we want to delete the shading, just click the....
How to convert Excel to PDF
02:50How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
How to insert pictures in Document
02:05How to insert pictures in Document
When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....