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. Let’s 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.

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