Embed an Excel Chart in a Word Document • Start Word and create a new document using the blank document template. • Type the following title then Tap the ENTER key on your keyboard and then select both lines Bayshore Travel Dance Cruises Fourth Quarter 2015 Revenue Report • Click the Home tab > Styles Group > More down arrow on the Quick Styles Gallery and choose the Title style • Click the Home tab > Paragraph Group and Center the headings • Position the insertion in the blank line below the title lines and type the following This report is generated by the Bayshore Travel agency and documents the quarterly revenue from sales of dance cruises for the fourth quarter 2015. Below you will find a snapshot of the revenue generated from sales of dance cruises to Alaska, Caribbean, Mexico, Europe and Hawaii. • Tap the ENTER key once Embed an Excel Object • Click the Insert tab > Text Group > Object menu and choose Object • From the popup window, click the Create from File tab • Click the Browse button and navigate to the folder where your Excel spreadsheet and chart are located • Double click the Excel file to open it and click OK.

• How To Connect Tables In Access

In Word, click File on the Ribbon, and then click Open. Click the damaged document, and then click Open. Step 2: Save the document in a different file format. In Word, click File on the Ribbon, and then click Save as. In Word, click Other Formats. In the Save as file type list, click Rich Text Format (*.rtf). Microsoft Excel for the Mac includes the ability to import live data from a database using an ODBC connection. This tutorial will describe how you can import sales data from an on-line sales database into your Excel spreadsheet.

Step 2: Now go to your Word document and press Ctrl + V to paste the contents into the Word file. In order to link, you have to click on the Paste Options button at the bottom right and choose either Match Destination Table Style and Link to Excel or Keep Source Formatting and Link to Excel. In newer versions of Word, you’ll see several icons. You can hover over them and you’ll find the same two options as mentioned above.

It provides a central place to see all of the data connections in a workbook, see where they are used, and modify, remove or refresh each one individually. With Excel 2016 for Mac, you now have that same Connection Manager you are familiar with from Windows. All of your connections are displayed, and you can click any of them to see where they are used in your workbook and to perform any action. The all-new Connection Manager in Excel 2016 for Mac. The Connection Properties dialog has been streamlined as well to match Excel for Windows, so that you now only see the properties that apply to your particular data connection.

Hi Travis, and thanks for your question. Do you need the full title of each table in your list of tables? If not, you could try highlighting just the first few words (or even just Table 1, etc) and making them the caption, then just this will pull over into the list.

The opening screen looks like this: The folder icon in the top right is what you need to choose so you can get to your newly created document archive. Tap it and you’ll see all the documents you transfered onto the iPad: Tap on the document you want — I tapped on the Word document — and you’ll see the import progress bar: Finally, it’ll finish up and, possibly, show this: Now you can tweak and modify it as appropriate or just view it. Pages on the iPad isn’t a fully functional editor, but it should keep you moving while on the road. As with Keynote, I encountered many problems with document portability and font libraries. I expect they’ll be fixed, but don’t be surprised if you need to tweak your document to get it to look great on your iPad. Now, still looking for? If so, you’re lucky because ya found it right here!

To start, open a blank Word document from the Home/New page. Position your cursor in the document where you want the table inserted. Graphic Grid/Select Table from Graph Under the Insert tab, click the Table button.

You can keep the caption with the image on the same page by editing the caption style to include “keep with next” or “keep with previous” depending on whether it’s above or below the image, which will keep them together on the page and allow you to copy them and move them with the image. The other option is to include a title in the text box then turn those back into caption style text at the very end, when everything’s in the correct order. I hope that helps a little, I know it’s not the complete answer you need, but I’ve researched that and I don’t think you can do it. Hi Travis, and thanks for your question.

Not sure what the problem with Word 2013 butt it doesn’t appear to work with these instructions. Thanks for your patience and help though. Hi Richard, I’ve just sat down and checked it all words for Word 2013 and it does – I created a Table caption, created two Figure captions, changed the colour of the captions to red, right-clicked on the Caption style, chose update style to match selection and it updated them all into red, then created two tables, one of figures and one of captions. I just want to check that you did it like this: you copied your caption, used Insert Caption and then pasted the text into the field, rather than highlighting the text and choosing Caption from the Style list.

If desired, you can then adjust the positioning of the columns so that the columns match between the two tables – this isn’t required but you may want to do it if the columns are supposed to be the same throughout. I just had a situation where my table was breaking with the cells before the bottom of the page and leaving a blank spot at the bottom of ONE PAGE in just ONE SECTION of a 30-PAGE TABLE. I did all of the checking/unchecking that is mentioned here and at other advice boards, but to no avail.

Sign up for the TekRevue Weekly Digest using the box below. Get tips, reviews, news, and giveaways reserved exclusively for subscribers.

You can change the amount of your caption that you mark as caption text, for example if a caption reads “Figure 2: number of people involved in the illegal activities of plagiarism, stealing and inventing results out of the total population” you could change it to “Figure 2: number of people involved in illegal activities – plagiarism, stealing and inventing results (measured by total population)” and then just highlight from “Figure” to “activities” and mark just that part as your caption text – that is all that will appear in your TOC. You can move the margins on your TOC so that the TOC is wider and can fit more on one line 3. You can manually edit the captions in the TOC – only do this at the very end, once everything else is finalised, because if you update the table, it will go back to the original caption. Thank you for your question and I’m glad you’ve found the posts useful. The page numbers moving issue sounds like you manually altered their position when you originally set up the table of contents. Delete the table and use one of the templates to set it up – if you don’t want to use a template, you can create your own layout, see the previous articles on Tables of Contents for that option.

I’ve tried to replicate the problem and consulted my APA Stylebook. The problem does indeed happen. I have tried all sorts of ways to split the table number and caption and then update the Table of Tables and nothing works.

When you make changes, they will be previewed so you can see them before you commit. While formatting or modifying a table, if the built-in selections aren’t close to what you want, you may just want to start from scratch. In this case, you can you the “New Style” dialog, which will be allow you to build a new table style based on current table styles. There’s little difference to this dialog and the modify dialog except that modifying is based off an existing table design. In the end, formatting your tables is going to come down to what kind of data you’re presenting and personal preference. We suggest that if you want to fully master tables, you create a blank document and mess around to your heart’s content.

Though it is more convenient to keep chapters separate as you work on them, your final submission will need to be one long document. You can combine all of the files into one large document (see steps below), and then use information in the following sections to generate your table of contents, lists of figures, tables and equations, and take control your page numbers. On the other hand, some people prefer to leave them as individual files, sometimes because combining your chapter files produces a file so massive that opening, editing, and saving it is prohibitively slow. If this is the case, you will need to manually create the table of contents, list of figures, and so on, and will need to set the pagination in each document. • Open the file that will begin your long document (e.g. “Chapter 1” or your front matter).

Are you stuck trying to create additional contents pages for the tables and figures in your document? Read on for simple instructions on how to do this. We’ve already learned how to. But what if you’ve got figures and/or tables and you want to show those in the contents pages, too?

You can convert data to tables instantly from the Insert Table command. Select the text. Go to Ribbon > Insert > Table > Insert Table Microsoft Word determines the required number of rows and columns by considering the text separators and then auto-fits the contents. The Convert Text to Table dialog box allows you more control if the previous operation doesn’t work out right.

Click it to reveal a drop-down list of the various ways that Word can format your table for you. Click one of the styles to choose it, and Word will automatically generate your in the location you specified.

The important thing is that Word now knows they are headings. You’ve given them an ID bracelet. Now, again, highlight the text to hyperlink and bring up the Hyperlinks box. This time, though, make sure you click on the box “Place in this document” all the way to the left. Because we have the headings formatted as headings, you’ll see that these headings are listed. Highlight the one to which you want to link and then click OK: Now “Section 2” in the text is linked to the heading for Section 2 of the document!

Find all the short cuts Related articles on this blog. Hi Doug, contact me via my contact form and I’ll try to help. However, do this first: copy the whole text (you can use Select All) and paste it into a totally new document.

You can right click on the TOC and bring up a menu, from which you can choose Update Field: Click on Update Field, and you’ll see an option to Update Page Numbers Only or Update Entire Table. If only the pages have changed, choose the first; if you’ve edited the text of headings, added new headings, or the like, choose the second option. New, updated TOC.

Do I have to manually add the heading or will it get automatically shown (as in case of Table of Contents)? Whose style need to be changed to ‘Heading 1’? Request you to explain in detail. Dear Liz, my issue is this, as I was formatting my thesis, using automatic numbering, everything went well until I started inserting the captions. In the main document and the appendix sections, the captions were inserted correctly. But as I wanted to insert additional tables and figures in the main document, the chapter number of the appendix section was inserted instead of the chapter number of the main thesis. Example is Figure A.1 instead of Figure 4.1 please help me resolving this issue.

How To Connect Tables In Access

To make a change across all of the documents that you’ve linked to your bookmark, go back to your common text file, and simply make the changes. Here, I’ve replaced the Groucho Marx quote with one from Oscar Wilde.

You can use the hyperlink menu to link to other places within your document as well. For example, you may want to link a mention of a section to that actual section in your document. Consider the following text: Here, we want to link the mention of “Section 2” in our text in Section 1 to the actual heading for Section 2, so that if our reader wants to jump to that section, he or she can do so with a click.

It’s often useful to provide a list of the figures and tables in your document, especially if it’s a long one, like a dissertation or thesis. They should be separate from the main table of contents, and listed below. The tricky thing is creating two lists, one of tables and one of figures. This is where people usually come unstuck.

Select paste link and make sure you click on Microsoft Excel Worksheet Object. If you don’t need to link the spreadsheet, you can just create the spreadsheet in Word. I haven’t encountered the problem on Microsoft Surface you mention though! ↓ • Dawn Post author Hi Michael, Did you do a Paste Link or just Paste when you inserted your Excel spreadsheet into Word? If you did a paste link, it sounds like the file that you are linked to no longer exists on your computer or server or maybe got moved to another directory? If you did a paste link, you should be able to update the spreadsheet in Excel and it would automatically update in Word.

Step 4: Click Yes and your table will reflect the new values. If you have both files open at the same time, you’ll see the changes live. There is obviously some pretty complicated mechanism that makes all of this work, but thankfully you don’t have to worry about it. It just works! Note that if you just copy and paste and don’t choose one of the linking options, you’ll just have a stand-alone Excel object inserted that won’t be updated when changes are made in the original Excel file. Also, using this method, you can’t edit the Excel data in Word and have it reflect back to the Excel spreadsheet.

How do I create a list of figures and a list of tables? We’re going to take a few basic steps here. They boil down to: • Mark all your figures as Figures and all your tables as Tables • Create a Table of Figures • Create a Table of Tables Once you’ve done that, you’ll end up with something like this: How to apply captions to tables and figures I know what you’ve done you’ve inserted your figure or table then typed its caption underneath, haven’t you? Like everyone else in the world. But let’s make life easier for you. It doesn’t matter if you’ve already typed in all the caption names just as straight text – let’s do this the proper way and we can move those typed captions into the correct place as we go! Click on the References tab.

The “Layouts” section lets you change how your graphic looks on the fly. Simply hover over any of the built-in options to see how it would look utilizing a different layout.

• To add a row at the end of a table, click the last cell of the last row, and then press the TAB key. Delete a row • Click a row or cell in the table, and then click the Table Layout tab. • Under Rows & Columns, click Delete, and then click Delete Rows. Add a column • Click a column or cell in the table, and then click the Table Layout tab.

Dann shows how easy it is in Excel with this short tutorial on Quickly bring your data into the proper format, so Excel can do its magic. Use these strategies to quickly flip rows, turn columns into rows, flip rows, and save a lot of manual labor. Also, take the help of if you run into a problem using the Transpose command. Paste Perfect Excel Tables into Gmail You will find a use for this simple workaround. By default, Gmail does not retain the spreadsheet format when you paste from Microsoft Excel. To email tabular data without sending it as a separate attachment, use Microsoft Word as a bridge. Select and copy-paste the Microsoft Excel table to a Microsoft Word document with the source formatting. Now, copy-paste from Microsoft Word to Gmail.

Essentially, but that didn’t work for me either (Don’t know why). I’ve managed to sort a work around though. Create two new styles (Figure Style and Table Style) both identical (Arial, 11pt, Italic) except for the name. Highlight all captions and click Remove All Formatting to clear whatever style Word has inserted it as.

If you click Yes, it will simply reload the latest values from the Excel spreadsheet and overwrite whatever values you may have changed. If you want to edit the original Excel spreadsheet, you can do it from Word by right-clicking on the data, clicking on Linked Worksheet Object and then clicking on Edit Link. This is useful if someone else created this Word document and you don’t know the location of the original Excel file. Insert Object Method The second way to link an Excel spreadsheet to Word is by using the Insert menu. Step 1: In Word, click on the Insert tab, click on the Object dropdown and then choose Object. Step 2: Click on the Create from File tab and click on the Browse button to choose your file.

Documents created in Microsoft Office for Mac are generally compatible with Microsoft Office for PC. Both Office for Mac and Office for PC are Microsoft products and, in most cases, you simply double-click on the Mac Office document to open the document in Office on the PC. However, in some cases, the document created on the Mac may not open on the PC. In these cases, you can save the document in a format that will be recognized by Microsoft Word on the PC. Save the document in the “Rich Text Format” and the document that was created on the Mac will open in Word on the PC.

Step 3: That’s it, now your table will be linked to the original Excel file. Whenever you update the Excel file and reopen Word, Word will ask you if you want to update the doc with the new data from the linked files.

Are you stuck trying to create additional contents pages for the tables and figures in your document? Read on for simple instructions on how to do this.

PS major advantage of word that reviewer, jury member, all people that comment and review the document can work with it and add comments, my PhD student used first LateX but then none of the other reviewers used it so he had to go to word regardsJ Like. No, in such a case you will need to cross-refer as follows: “ The right panel (a) in [Figure] shows the results of MyTechnique and the central panel (b) shows myOtherTechnique” where [ Figure] is an automatic cross-reference and the rest of the text is manual. Concerning the advantages of Word for collaboration, it is indeed often one of the most powerful platforms. Yet I often collaborate much more effectively without even touching Microsoft Word.

First – I’m having problem with the caption text not changing to the style I created. My text styles appear differently to what I’ve designed. My caption styles are italic, Arial, 11pt, colour black and I see that on the style palette, but when I highlight the text I want to change and choose that style it changes to non-italic, 10pt, colour blue Calibri. Second – There does not appear to be anyway I can do what you suggest. I click references > insert table of figures > Options (To choose the style) but the Table of Figures Options has a style list that just doesn’t contain the styles I created and there doesn’t seem to be anyway to add them to that list. Also, if in Table of Figures, I select Figure as the Caption label the table contains figures and tables. If I select Table as the caption label I get both again.