What if Rosamine has access to the store sales information Excel file directly? With this scenario, she can place it directly into her Word document with no need to make her own table. Her Word document is ready for more text and additional data. ![]() Her work complete, she clicks off to the right. Rosamine resizes the table by holding down the left mouse button and dragging the sides of the table to the correct size for the report. Now the table is complete, but it still shows too many unused cells. The last table change Rosamine uses is to select the titles and totals rows and bold each of them to contrast with the other data. Option 2 for Table Integration One way is to simply click on the Word window and it will move forward in front of the Excel window. To make the table look more defined in the document, Rosamine selects the entire table, then the Border button, then selects the “thick box border” to be placed around the outside of the table. Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies. Rosamine selects the top and bottom rows, clicks on the paint bucket button, and chooses a green color for the table. The table needs a contrasting color to make the titles and totals stand out. Next, Rosamine centers the Quarter numbers by selecting the three quarter cells and clicking on the centering button. With the bottom cell selected, Rosamine clicks the AutoSum button, which totals the three sales figures for all stores for the GM to easily see what total sales were generated from the second quarter. Rosamine selects and formats the column of numbers to be currency cells and to display the dollars generated from sales for the second quarter of the year. All data to be merged is present in the first. docx, but is a corruption that occurred at some other point during the document. For example, to address readers by their first name in your document, you'll need separate columns for first and last names. Some (2 out of 6) of my embedded Excel spreadsheets have been changed to pictures (instead of spreadsheets) in my Word 2011 docx document - any ideas what might cause this to happen I can confirm that this is not just when I converted a. ![]() Make sure: Column names in your spreadsheet match the field names you want to insert in your mail merge. Rosamine has entered the sales figures from the three different stores, and wants to make additional changes to the table. Here are some tips to prepare your Excel spreadsheet for a mail merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |