(Again, note that linking is the only difference between these two options.) This option should fit the data within the margins as a Word table, with data wrapped within cells as necessary. To have the data adapt to the styles available in Word, click Use Destination Styles or Link & Use Destination Styles.(Note that linking is the only difference between these two options.) To keep the data as an Excel table object, click either Keep Source Formatting or Link & Keep Source Formatting.From the resulting options you should notice six options in the Paste Options area: Then, display the Home tab of the ribbon and, in the Clipboard group, click the down arrow under the Paste tool. When you copy the table in Excel and switch to Word, click where you want the data inserted. You can also, within Word, choose from different available pasting options for the table. Since the table is bounded by the outer single-cell table, it won't extend beyond the margins of the page. You can then paste the Excel data into that single cell, which results in Word creating a table within a table.
Convert excel to word full#
One option is to, in Word and before pasting, create a single-cell table that is the full width of the margins on the page. There are a few ways you can approach this, with most of the solutions occurring on the Word side of the process. Jerald wonders if there is something he can do, in Excel, to ensure that the data will stay within the page margins in Word. Every time he pastes the data, the "table" in Word extends beyond the right margin. He creates his financial models in Excel and then pastes the Excel data into a Word document before printing. Jerald uses Excel quite a bit in conjunction with Word.
0 kommentar(er)
