Pros: Fast and convenient, good for large tables, conserves original formatting, and updates instantly with source data updates.If you wanted to, you could use this feature to create a realtime dashboard in Word to display any important data points that someone may change in an Excel file. This essentially lets you create a live view from Word into changes someone is actively making in any Excel file. The changes take effect in Word even if you haven’t saved the changes in the Excel file. #CAN YOU PUT WORD ON A MAC UPDATE#If you return to your original Excel file and make any changes to the data in any of the cells you pasted, you’ll see those changes immediately update in your Microsoft Word document. You’ll see that the inserted Excel data looks the same as in the previous section, but there’s a significant difference. The procedure to do this is identical to the one above, except in the Paste Special window you want to make sure to select the Paste Link checkbox. The best way to insert an Excel worksheet into a Word doc is by pasting it as a linked embedded object. Insert An Excel Worksheet As A Linked Object
0 Comments
Leave a Reply. |
AuthorSarah ArchivesCategories |