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

Hyperlink in WPS Office Spreadsheet

Uploaded time: August 27, 2021 Difficulty Beginner

Hyperlink in WPS Office Spreadsheet

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

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

2-2.gif

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

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

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

3. Click Customersto jump to other documents.

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?

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