[Libs-Or] Tech-Talk: EXCEL/G-Sheets - Embed a Worksheet into a Document

Tue Oct 14 14:16:03 PDT 2025

Welcome to the latest issue of Tech-Talk!

Having trouble reading this email? You can view the tech tip<https://www.tech-talk.com/tired-of-drab-reports-use-pivot-tables.html> online instead at:
https://www.tech-talk.com/login/oregon

When prompted for a username and password, use ORLIBTECH for both.

Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon.
Insert your data in a doc

[https://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png?rdr=true]

[https://files.constantcontact.com/ee1208b4001/4de45d8f-81d5-43e2-b1f1-bb033bc5098d.png?rdr=true]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsBQ4sZH5jqtcbibe1QFh6F7P0Azt3qfzmcm4v_Z3VI8p4AfaCTrEmgpkLYzuuULV1Kubw4OMXGIiD1Rik5Kw5I0XCvtUnFJHzuY_DM8FAxlGuJ95XfPFz6H7_D67PPozAc6_gZUR2krm4Dcp3uwM38I=&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

Photo by Ranae Smith<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsBQ4sZH5jqtcjUuZhFHh5JmqxSVHFcFPu9JoRVKc6NgiXj-v-w_JfC0XEd4PgIh-ySZRWv0mTDoud43xwR4o2RPt1DbAMKlo_VFiLhtIKx0fAVMgoKiXnbc5Zp4Pb3gaZGbfS5wCVm5UC48iG_qvcPLRTPkpg9ZG1gU7p4CIpmOHaS4pPDxBmVlCtlTcsujksk7YOYq6evAp1cNOd2sE2sA=&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==> on Unsplash<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsBQ4sZH5jqtcJ0qWN7H60C36ue_JyP8cdL_mfe-xGOjqdiXbQ_lCDrXhf4Sus1NTKyb-WlkbqkLZk5J2TEDBbn18uImPMEtJLL5PyJBJZu0N3Wja-XlvxL7nVLXwan6V9ZG71KAAQuXY3dgBQtRJ-ygsuEJmSHgU96uRjmyE77Hns0zN0eLnneq6bQiZyj-XrGPbU3KIPEIgimzT5xSB7bOKcQYdOxx9OBIDCSBMPpKY&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

[https://files.constantcontact.com/ee1208b4001/e25f6bcf-26a8-4e59-91f2-cc248962042d.png?rdr=true]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsKw1O9KZSJlvqPeETWNEl1mZFreKGseTyI0dzpp_TO_aNKVp3j4Uup0kbamVnUX2yZk0KveW6-4pN88leacw4MEwJwPalwwguWvoVKc6_khPZAD4a2gUwodYIl4TNB1VJ4fCiVrCSGtZB4RrSaN6cOMhVScsnmclxA==&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

Webinars for You

NOTE: Webinars begin at 12 Noon PT and are one hour long.

October 22: [LEADERSHIP] Meeting Mastery: Skills Every Leader Needs Why Attend: You want to learn how to lead meetings that are focused, respectful, and productive.

November 5: [EMAIL] Organizing Email: Clear the Clutter, Stay in Control. Why Attend: You're tired of inbox overload and want ways to reduce it.

November 19: [INTERNET] Internet Search Techniques: Search Smarter, Save Time<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsANSYpuL8CfLTLRMzuzi68S2V4pHS6zNtbQ-wvimgE4veCR1pVULFiUcedPmeZuhgOas94yTe7_yUPKzyh7zMwsUbAduznq_ojt9N53PDK2vtewH9YQb6Xvc6AJ4gEPAcvojZzd_ChS4Hs3RC4XYw9ASJ3d2LLMvdw==&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>. Why Attend: You want faster and more efficient search results.

December 3: [EXCEL]  Spreadsheet Storytelling: Interactive Features You Need. Why Attend: You want tips on bringing out your messages.

View Webinars and Register Here<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsEg9kq37yGt_f9vgrB2yxzEEKo9TPHl6Wbb2k9lj7XpqExPXbys3H2qBlbTFM-fW-JwyL_sQXFPXHRditPMu3dCimJQ2hxK5_ejc_tjKV5NVcLNvhq4jIbs=&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

[Time]

Time is running out!

The Tech-Talk User Survey ends next Monday, Oct 20th.

Please take a few minutes 
and quickly go through it!

Take Helpful Survey Now!<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsHW9MaznXz61jdj-jnqbKkeZDfj-bdjBL4dNpqzG9mHOniG0kPi89Z0d6JLwpMNXkBEaQBLvRW-Ab3Egoya4FzCS4VqkpVPE1eckzEziJE020oi7Nosn-arJe3uPrUe5nhXpNxdTUjTDZmr99y9cofp-5yr2V4c82Ldil44uqtDWazrCCW7Mj23tXnQ3dTBSyRNx0LNeRU_8SKs6Y1M00QqWUerfhQIGu1imJCgU2uF4&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

EXCEL / Google Sheets - Embed a Worksheet into a Document

Advanced

[embed worksheet]

You're writing a proposal, report or article with statistics that explain your ideas. You have set up a supporting Excel spreadsheet (or Google Sheet) but you want the info to be in your main document. Instead of trying to replicate the content using a table in your doc, did you know you can embed the spreadsheet right into it?

Sometimes your documents need to contain worksheets or charts as well as text. Or maybe you want to have a quick way to refer to the whole Excel file. You can quickly embed (or insert) a copy of an Excel worksheet directly into your Word (or Google) document. And, depending on how you set it up, when you make changes in the spreadsheet, the content will update in the doc as well!

Embed Options Using Excel and Word

There are a few ways to Display and Link OR embed an Excel spreadsheet.

·     Display and Link means that you copy the spreadsheet rows and columns to show in your document. If you want to be able to update the spreadsheet and have the content in your doc reflect the changes, you can link it. This works well when the content doesn't have too many rows and columns as they need to fit on a Word page.

·     Embed as an Object lets you create a link to the spreadsheet right in the Word doc. This is handy when you are referring to supporting data, but there may be too many rows/columns to be readable on a page.

Display (With Option to Link) Excel Content in a Word Document

·     First, open both the Word document and Excel workbook.
·     In Excel, select the range of cells (columns and rows), or chart you want to include in the Word document.
·     Right-click, then Copy.
·     In the Word document, click on the line where you want the information to appear.
·     Right-click to see the Paste Options (or in the menu go to Paste) and you'll see several choices for how the content can be displayed (see the image below).

[paste options]

Then, to add just the content without linking back to the original file choose from these options:

1.  Keep source formatting - Retains the formatting from the original file, in this case, the Excel spreadsheet.
2.  Use destination styles - Uses the formatting of the Word doc.
3.  Picture - This lets you paste a static image of the Excel data (and it will not be editable in the Word doc).

Or, if you want to link the two files together so that when you make a change in the Excel spreadsheet it will dynamically update in the Word doc as well, choose either:

1.  Link and keep source formatting - Retains the formatting from the Excel file, and will update the Word doc if you make changes in your Excel file.
2.  Link and use destination styles - Matches the style of the Word doc and will update the Word doc if you make changes in your Excel file.

IMPORTANT: Usually, everything will update just fine. If not, you need to give the data a boost by UPDATING the link in the Word document. In the table, right-click anywhere in the pasted/linked table and choose "Update Link". (Or Press F9 on the keyboard.)

TIP: If someone else is updating the spreadsheet, you will want to "Update" every time you open the Word document to make sure the newest info is there.

ANOTHER TIP: If you send the Word Doc to someone and the file is linked to the Excel spreadsheet, you need to send both documents.

CAUTION: If you move the Excel file to a new folder location it will "break" the link to the Word Doc. So be sure to save both files in one folder together.

Embed the Excel Worksheet in a Doc (as an Object)

If you have a large spreadsheet with many rows and columns of data that you want to refer to, the Embed an Object option lets you link from your Word doc to the Excel file.

1.  In the Word doc, place your cursor where you want to add the Excel link.
2.  In the ribbon go to the Insert tab and in the Text group click Object and select Object.
3.  Select the Create from file tab.
4.  Use the Browse button to choose the Excel file. Don't click OK!
5.  CAUTION: If you click OK, the contents of the Excel file will be placed in your Word doc.
6.  Instead, check the Link to file box so that the files will be connected and when you make changes in the spreadsheet they will be reflected in the Word file.
7.  And check the Display as icon box so that when clicked, the reader of the Word document can go directly to the Excel file.
8.  Then click OK.
9.  TIP: If you want a different icon to be displayed as the link, use the Change icon button to upload an image in place of the Excel icon.

[embed object]

[embed]

Now, in your document, there will be an icon that when clicked, will open your Excel spreadsheet.

You are not displaying the data, but giving a way for people to get to it.

TIPS: Yes, you can drag the image to be larger. Also, before embedding, give the doc a name you want to be shown.

Embed a Sheet in a GOOGLE Doc

TIP: Not all spreadsheets are suitable to embed in a Doc. For instance, if you have more than 400 cells Google will allow them to be copied and pasted, but they will not be linked.

There are two options to paste a spreadsheet – either with or without a link to the Sheet. The steps are the same in either case:

·     Open the Google Sheet and select the cells you want to copy into your Doc.
·     Right-click and select Copy (or press Ctrl+C or in the menu go to Edit, Copy).

[https://files.constantcontact.com/ee1208b4001/dfb11c38-8cdd-47d4-98e3-f0577c9df83b.png?rdr=true]
·     In the Google Doc click where you want to add the content and enter Ctrl V (Do NOT right-click Paste nor Edit, Paste unless you want to download an addon).
·     Choose "Link to spreadsheet" or "Paste unlinked" and click the Paste button.

[Embed a worksheet]

Excel 365 Web - Can You Embed a Spreadsheet?

While it is always true that the Microsoft Desktop software is more fully featured than a browser-based suite (like 365 Web or Google Suite), there are often alternative things you can do to achieve much the same results.

So, if you have an Excel 365 Web spreadsheet you want to put in a Word for Web document, one thing you can do is to link to a spreadsheet or paste a static table/chart in it. You just cannot embed an editable sheet.

Here is how:

Step 1: Upload your Excel file
·     Go to OneDrive or SharePoint.
·     Upload your Excel workbook if it’s not already there.

Step 2: Open your Word document in Word for Web
·     Go to office.com → Word → open your document.

Step 3: Copy a link to the Excel file
·     Open the Excel file in Excel for Web.
·     Click Share → Copy link.
·     Make sure the link permissions are correct: Anyone with the link can view/edit (choose based on your needs).

Step 4: Insert the link in Word for Web
·     Go back to your Word document.
·     Select the text or location where you want the spreadsheet link.
·     Click Insert → Link → Paste the Excel link → Apply.

Now, anyone who clicks the link in your Word document will open the spreadsheet in Excel for Web.

Optional: Display a preview table

You can also copy a range of cells from Excel for Web and paste into Word for Web. This shows a static table, not live. Updates in the source file won’t reflect automatically unless you use the link.

[https://files.constantcontact.com/ee1208b4001/a0642aa4-7c96-4078-93c8-ed830168da0b.png?rdr=true]

Upcoming EXCEL WEBINAR:

December 3rd

Excel Storytelling: Interactive Features You Need

Boost your Excel skills with advanced features that tell a compelling story. Learn conditional formatting to highlight trends, create dropdowns and check boxes for accuracy and interaction. Discover the feature Format as Table.

Register for the Excel Webinar Here<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsEg9kq37yGt_f9vgrB2yxzEEKo9TPHl6Wbb2k9lj7XpqExPXbys3H2qBlbTFM-fW-JwyL_sQXFPXHRditPMu3dCimJQ2hxK5_cQSPJmQxwgOsdYEb5uorxQ=&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

[https://files.constantcontact.com/ee1208b4001/f8f1ecc8-4884-4c21-8ed0-cf647e6db944.png?rdr=true]

Communications: Email

Making a lasting impression

It's so easy to make a statement ... whether it's a suggestion, a positive comment, or even just a thank you ... in our daily conversation. We do it all the time! Especially in email. But how can you make it more compelling?

Examples of the kind of statements we make every day...
·     Maybe we could spend 15 minutes in a Zoom meeting.
·     Thanks for the money-saving tip.
·     Your proposal was well written.

Nothing wrong with any of those, right? It's all very straightforward! But what can you do to let the reader (especially in email) know that you really mean what you are saying?

In other words, you want them to internalize the importance of what you've told them. You don't want them to gloss over your statements.

Solution: Reinforce your statement with a follow-up sentence. Here are examples.

1.  Maybe we could spend 15 minutes in a Zoom meeting. That would certainly help me!
2.  Thanks for the money-saving tip. I appreciate it!
3.  Your proposal was well written. It was clear and powerful.

If you want people to truly appreciate what you have to say, get in the habit of reinforcing statements you want readers to understand, embrace, and remember.

CHALLENGE: Try this in your personal conversations as well.

[https://files.constantcontact.com/ee1208b4001/e8848d0d-4903-48da-85d0-7903dddee893.png?rdr=true]<https://opiayfbab.cc.rs6.net/tn.jsp?f=001uU1bVBN-0ZRsf5kHgH2W_03xnkdpaeETWCrF6XuIzhcbGnSkh-UtsF7cPcaps3o0Y_3ANhsU1yztPoRoIX704qXrFWIhXhkyQzwM0BCwibE0P4z86oeZvEfeMC9tOS_VDfDte1oMM43yT2P-Ulu6v8vFodUWJVtQXGJ7kOeOKFE=&c=5FR0o47DSVCwdZSL5jjZchwTOOUQiZuv0r798M-_rCrsug4BB39mjg==&ch=uKeTO-xsn_ndmEapEeb2oxWTLAqKLUWvAOvKmQ5u7CTJwqd6cYDV6w==>

Copyright 1996-2025 Shared Results International. Published weekly. Distribution is limited by license. For information on how to include additional recipients, contact support at tech-talk.com<mailto:support at tech-talk.com> 585-615-7795.

Cheers,
Darci Hanning, MLIS (she/her/hers)
Public Library Consultant / CE Coordinator
Continuing Education Resources: https://slo.oregon.gov/conted/
State Library of Oregon | Library Support and Development Services
971-375-3491 | darci.hanning at slo.oregon.gov<mailto:darci.hanning at slo.oregon.gov> | www.oregon.gov/library<http://www.oregon.gov/library>

[State Library of Oregon (Logo)]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20251014/9bd1f85f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 15548 bytes
Desc: image001.png
URL: <https://omls.oregon.gov/pipermail/libs-or/attachments/20251014/9bd1f85f/attachment.png>