1. Open the file you want to hyperlink, select all documents, and then click the copy path in the toolbar.

2. After copying the path, open Excel to paste the path.

3. After pasting the path, list the text to be hyperlinked, and then enter the formula = hyperlink (A 1, B 1).

4. Press Enter to add a hyperlink to the text.

5. Pull it down and copy it.

Extended data:

Spreadsheets can input, output and display data, and can also use formulas to calculate some simple addition and subtraction operations. It can help users to make all kinds of complicated tabular documents, perform tedious data calculation, and display the input data in tabular form after all kinds of complicated statistical operations, with excellent visibility. At the same time, a large number of boring data can be intuitively displayed as various exquisite color business charts, which greatly enhances the visibility of data. In addition, spreadsheets can also print out various statistical reports and charts. EXCEL is a spreadsheet component in Microsoft OFFICE software, and the forms it produces are one kind of spreadsheets, in addition to CCED made in China and spreadsheets in Jinshan WPS.