How to Batch Convert Text to Hyperlinks in Spreadsheets 2013

Have you ever run into this problem before, when you open your Excel or Spreadsheets files, there’re tons of links inactivated, you have to select and activate each link one by one? With Kingsoft Spreadsheets, we can help to save you the trouble. You are allowed to activate multiple hyperlinks at once.

Follow the steps below to batch create hyperlinks

Step 1: Select the cell range containing the inactivated hyperlinks. The range of cells can be discontinuous.

Step 2: Under 2013 Style interface, go to Format.

Step 3: select Convert Text to Hyperlink from the drop down list to finish.

What kind of hyperlink or url can be activated?

A URL containing a protocol, such as HTTP, FTP, or FILE, a Web server or network location, a path and file name, and you can also activate an Email Address. The following illustration defines the parts of the URL:

1. Protocol used (http, ftp, file) such as:
http://example.kingsoftstore.com/index.htm
file://ComputerName/SharedFolder/FileName.htm

2. Web server or network location, such as: 
www. Kingsoftstore.com

3. Email address such as: 
support@kingsoft.com