<\/figure>\n\n\n\nChoose Paste Options<\/h2>\n\n\n\n Standard Excel pasting can be sufficient for some people, but Word gives you more control over pasting methods. Let\u2019s see which of these methods you can use to achieve the desired effect.<\/p>\n\n\n\n
Instead of using a keyboard shortcut to paste the table, use the right mouse button inside your document to insert the table.<\/p>\n\n\n\n <\/figure>\n\n\n\nIf you use the second position, called Use Destination Styles (S), it will insert a table with the row and column lines, but without formatting.<\/p>\n\n\n\n <\/figure>\n\n\n\nPaste as an image<\/h2>\n\n\n\n So far, we pasted the table as values, but we can also paste it as an image.<\/p>\n\n\n\n
Right-click inside a document and choose the second position from the right.<\/p>\n\n\n\n <\/figure>\n\n\n\nIt will paste the table as an image, so you won’t be able to edit data inside it.<\/p>\n\n\n\n <\/figure>\n\n\n\nPasting table and adding borders<\/h2>\n\n\n\n If you want to keep table formatting, but also want to have borders, you can absolutely do it.<\/p>\n\n\n\n
First, paste the table with Ctrl + V<\/strong>. Click inside the table and choose TableTools >> Layout >> Table >> Properties<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nFrom the new window choose the Table<\/strong> tab and click the Borders and Shading<\/strong> button.<\/p>\n\n\n\n <\/figure>\n\n\n\nFrom the Borders and Shading Window<\/strong>, under the Setting<\/strong>, choose All<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nIt will add borders and keep the formatting intact.<\/p>\n\n\n\n <\/figure>\n\n\n\nYou can also change color to make them similar to the table inside Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"
Depending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Convert Excel Data to Word Table<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n