![]() ![]() ![]() Select the cell or cells that you want to link to and press Enter.Įxcel will return to the original worksheet and display the values from the source worksheet. Switch to the worksheet that contains the cells that you want to link to. If you want to use a function, such as SUM, then type the function name followed by an opening parenthesis. Select the cell or cells where you want to create the external reference. To use the link in a formula, type = in front of the link, choose a function, type (, and then type ) after the link.Ĭreate a link to a worksheet in the same workbook If you change it, it will automatically change in the destination workbook when you refresh your browser window. Select the cell where you want to place the linked data, then go to Home > Clipboard > Paste > Paste Link.Įxcel will return the data you copied from the source workbook. Switch to the destination workbook, and then click the worksheet where you want the linked data to be placed. Press Ctrl+C or go to Home > Clipboard > Copy. In the source workbook, select the cell or cells you want to link. Open the workbook that will contain the external reference (the destination workbook, also called the formula workbook) and the workbook that contains the data that you want to link to (the source workbook, also called the data workbook). Create an external reference between cells in different workbooks ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |