convert excel spreadsheet to microsoft word table

Convert excel spreadsheet to microsoft word table how to#
Convert excel spreadsheet to microsoft word table download#

It will add borders and keep the formatting intact. Put the mouse in the place where the table should. For example, the row headers no longer include the. Note: Table features are no longer available after you convert the table back to a range. Right-click the table, then in the shortcut menu, click Table > Convert to Range. In the Tools group, click Convert to Range. If you have a blank line between each record, add one to the total. Click anywhere in the table and then go to Table Tools > Design on the Ribbon. Enter the number of lines per record in the the 'Number of columns' field. border spreadsheets may extend beyond the sheet. The result of our work: This method has some drawbacks: table inserted as a graphic object that is it cannot be edited. Check is the source for insert selected correctly. Click the Insert tab and then click the Table button. «Paste Link» - «Microsoft Excel Worksheet Object».

Convert excel spreadsheet to microsoft word table how to#

Click inside the table and choose TableTools > Layout > Table > Properties.įrom the new window choose the Table tab and click the Borders and Shading button.įrom the Borders and Shading Window, under the Setting, choose All. How to convert a table from Word to Excel Select a table in MS Word. Select all of the text that you want to convert into a table. If you want to keep table formatting, but also want to have borders, you can absolutely do it.įirst, paste the table with Ctrl + V. It will paste the table as an image, so you won’t be able to edit data inside it. Right-click inside a document and choose the second position from the right. So far, we pasted the table as values, but we can also paste it as an image. If you use the second position, called Use Destination Styles (S), it will insert a table with the row and column lines, but without formatting. Instead of using a keyboard shortcut to paste the table, use the right mouse button inside your document to insert the table. Let’s see which of these methods you can use to achieve the desired effect.

Standard Excel pasting can be sufficient for some people, but Word gives you more control over pasting methods. The easiest way to copy an Excel table to Word is to select all table cells in Excel ( A1:F5), copy these cells ( Ctrl + C), and paste them ( Ctrl + V) into Word. There are background colors and conditional formatting. This is an Excel table we are going to use.

Convert excel spreadsheet to microsoft word table download#

Convert-Excel-Data-to-Word-Table Download Fileĭepending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a Word table.