I now also want to paste part of an Excel table to word and merge the tables. I got it working pasting Excel range to Word as a picture. You can resize an image file by dragging the corner of the image.I know, maybe this is not the right forum but it is the one I usually use. As it has been converted into an image file, it cannot be edited in Word. So, if you edit the values in the original excel document, it will be updated in the Word document.Īs a Picture - will paste the excel object as a picture into the Word document. Link & Keep Source formatting - will paste table using the formats from the excel document, but it will also link the table to the excel file. So, in this example, the yellow fill of the header cells and the centered text of the headers have been removed. Use Destination Styles - will paste the excel table using the styles from your Word document. Drag to widen or narrow the width of a column.
You can also resize the table's columns and rows, with the black double arrow that appears at the border of columns and rows. When you hover over the corner, the mouse will change to a double-headed resize arrow (white or black double arrow) and you can then drag & drop to the table boundary to size. Resize a table in Word by dragging the resize handle (small square) in the bottom right-hand corner of the table. If you have a wide table, you may need to use Section Breaks in Word to apply a horizontal page layout for that particular page. Keep Source Formatting - retains the format from Excel, but you may need to resize the table in Word as the margins in Word will be that of an A4 portrait layout. You see the Paste Options when you paste (ctrl+V) or right-click in Word to paste: When you paste, you can choose how it pastes into the Word document: You can cut and paste tables and diagrams from Excel into Word. Student Digital Skills and Assistive Technology.
0 kommentar(er)
