Create a reference with a mouse click

To create a reference to data from an external document in a formula or function of the current document by clicking the mouse, follow these steps:

1.Open a document that will contain a formula or function with a reference, and an external document to which data you want to create a reference. If the external document was opened earlier, make sure that all the changes you made are saved in it.

2.In the current document, select the cell where you want to enter a formula or function.

3.In the Formula bar or directly in the cell, enter the = sign and start typing the formula or function.

4.Navigate to the external document and select the sheet whose cell or range of cells you want to refer to.

5.Select the desired cell or range of cells on the sheet. The Formula bar of the external and current document displays the entered formula or function from the current document. If necessary, the formula/function can be edited both in the current and in an external document.

6.Go to the current document, finish entering the function or formula and click in the Formula bar or press Enter.