Hyperlink in WPS Office Spreadsheet

Uploaded time: 2021-08-27 Difficulty: Primary

Hyperlink in WPS Office Spreadsheet

Hyperlink in WPS Office Spreadsheet

Graphic skills

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.

WPS_01.gif


3. In the pop-up dialog box, click Place in this Document.

4. Under the Cell Reference, select other spreadsheets as needed.

5. Select Statistics, and click OK to complete the settings. 

At this time, we click Statistics. It will automatically jump to the Statistics spreadsheet.

WPS_2.gif

  

Select a cell, use the shortcut key Ctrl+K to open the hyperlink dialog box. If we want to insert a web link, we can enter the URL we want to link to in the Existing File or Web Page and click OK

WPS_3.gif


We can personalize the name of the URL hyperlink by entering the text you want in the Text to display edit box in the Hyperlink dialog box. For example, enter WPS Office.The text content of the hyperlink entry then becomes WPS Office. We can also embellish the hyperlink text with a format painter. 

WPS_4.gif


If you want to learn more about format painter, you're welcome to enter WPS Academy. At this point, we can click once to jump to the URL page just entered.

WPS_5.gif

 

We can also use the Hyperlink function to link to other documents.

1. Click the text Customers, use the shortcut key Ctrl + K to open the Hyperlink dialog box. Select Existing File or Web Page.

2. Click the document to link to, and click OK.

3. Click Customers to jump to other documents.

WPS_6.gif

 

Using this function, we can have a quick access to spreadsheets and other links or files. To be office excel advancers, we could learn how to use WPS Office Spreadsheet online in WPS Academy. Did you get it?