WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

How to insert and delete hyperlink

Uploaded time: February 21, 2022 Difficulty Beginner

How to insert and delete hyperlink

How to insert and delete hyperlink

In some cases, we may need a hyperlink to jump to a website or another table, so how can we insert it?

Take this table as an example.

Select a cell, click Edit, select Tools, and in the Insert tab, click Hyperlink.

Four types of hyperlinks are available.  They are Web Page, Place in This Document, Email Address, and Local File. Lets know about them one by one.

·Web Page

1. Input the WPS Academy website in the Address text box. Here we can change its network protocol type.

2. To hide the website, we can also customize its Text to display. Input WPS Academy and click OK, or we can click the cell, select Edit in the floating window and customize the text to display in the text box.

3. Then click the hyperlink to jump to the website.

4. If we want to delete it, click Delete Hyperlink.

· Place in This Document

1. Input A1 in the Cell Reference area and select Weight and BMI Chart in the Sheet Selection area.

2. Then click the hyperlink to jump to cell A1 in the Weight and BMI Chart.

3.gif 

· Email Address

1. Input the Email Address and Subject, and click OK.

2. Then click the hyperlink to jump to the email quickly.

· Local File

1. Select Choose File in File Path, select a local file, customize the text to display, and click OK.

2. Then click the hyperlink to jump to the linked file quickly.

That's all about hyperlinks. You are welcome to explore more features for WPS Spreadsheets in WPS Office for windows.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.