Simply type an equal sign in an empty cell, move to the other workbook or sheet and then click the source cell to automatically enter the reference. When you press 'Enter,' the link is established to the selected cell. If you're linking a cell in another workbook, save both workbooks first, so Excel uses the correct filename. Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Office 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 When you use Office, you have several ways to share information among applications. Copying and pasting is one way, but you can also link information so that it is updated automatically or embed the information so that it is updated only when you manually update it by opening the file. You can also link to a portion of a file — for example, a few cells in an Excel sheet — by using a linked object. Advantages and disadvantages of linking vs. Embedding Linking Embedding Updates information automatically Makes it easy to open the application that the embedded information was created in Keeps file sizes small Results in file sizes that are larger than those with linked information Requires both files to be accessible to view the information Requires both files to be accessible to update the information, but not to view it Is not suitable if you want to distribute the file online Is suitable if you want to distribute the file online because all the information is contained in one file. ![]() If you maintain data in an Excel file and related information in a Word file, you can link the information to make updating easier. For example, suppose that you want to link the latest sales returns to your monthly status report. The status report is a Word document, and the sales returns are on an Excel sheet. By linking the document and the sheet, the status report updates automatically whenever the sales returns are updated. Or, you might want to insert instructions from a Word document into several Excel files. By using a link, you can update the instructions, and the updates appear in all the Excel files. • Click where you want to insert the link. • On the Insert menu, click Object, and then click From File. • Locate and click the file that you want to link to, then click Options. • Select the Link to File check box. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. Mac os x for windows. The only option is to use a newer version of the software. The question of CS2 compatibility comes up during every recent Mac system upgrade. For example, if you don't want the status report to change when the Excel sheet changes or you do not want the Excel sheet to change when the instructions change, you can embed information. Because the information is totally contained in one file, embedding is useful when you want to distribute an online version of your file to people who don't have access to the embedded file. • Click where you want to embed the file. • On the Insert menu, click Object, and then click From File. • Select the file you want, and then click Options. If you embed an Excel sheet, it must be the first sheet in the workbook. • Clear the Link to File check box. You can link to part of a file. For example, in a monthly status report, you might want to link to a specific range of cells from an Excel sheet instead of the entire sheet. For example, you might want to link to specific instructions from a Word document instead of the entire document. • Select the information that you want to paste — for example, a range of cells on an Excel sheet. • On the Edit menu, click Copy. • Switch to the other file, and then click where you want the information to appear. • On the Edit menu, click Paste Special, and then click Paste link. • In the As box, click the type of object, for example, Microsoft Excel Worksheet Object, and then click OK. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. For example, suppose that you want to embed the latest sales returns in your monthly status report. The status report is a PowerPoint presentation, and the sales returns are on an Excel sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |