0 votes
44 views
in Excel by (26.1k points)
How to transfer a table from Excel to Word

1 Answer

0 votes
by (149k points)
 
Best answer
How to transfer a table from Excel to Word: a simple solution The easy way Special insert Insert from file Export a table from Excel Possible problems Conclusion Video instruction Copy by table Copy as picture Insert in Word

How to transfer a table from Excel to Word: a simple solution

image Today, everyone knows that Microsoft Excel is the best and most convenient multifunctional spreadsheet program. It will be very difficult to repeat the same steps in a text editor. But how to combine the work of these two applications? In this tutorial, we'll show you how to transfer a table from Excel to Word and look at a few basic methods to do it.

The easy way

So, let's get down to business.

  1. Let's start by creating a table in Excel.

image

  1. Now we need to select the entire table.

image

Copy by table

After that we have three options:

  1. Press the hotkeys [knopka]Ctrl[/knopka]+[knopka]C[/knopka] or right-click and select "Copy" from the context menu.

image

  1. Click on the "Copy" icon on the main toolbar.

image

In all the methods described above, we will copy the object while preserving the properties of the table. That is, we will be able to edit this table in the future after we insert it into a Word document.

Copy as picture

But if in the third method you click not on the button, but on the “triangle” next to it, you can see an additional menu. In it, you need to select the second item.

image

Insert in Word

It does not matter in what format you copied the contents of the table - you can transfer all this to the document in the following ways:

  1. Press the hotkeys [knopka]Ctrl[/knopka]+[knopka]V[/knopka]. As a result of this, you will see the following.

image

In this case, all functions for changing the content and data format will be available.

image

  1. Open the Word editor and click on the "Insert" button on the main toolbar.

image

As a result, the table will be inserted automatically.

image

But if you click not on the button, but not on the “triangle” below it, then you will see several different options.

See also:   autofilter in excel

image

Let's take a closer look at them (hovering over each icon will give you a preview):

  • while maintaining the original formatting;

image

  • use the styles of the final fragment;

image

  • link and keep the original formatting;

image

  • link and use final styles;

image

  • picture;

image

  • save text only.

image

Special insert

After you copy the table (not as an image), go to the "Home" tab in Word, then click on the "triangle" under the "Paste" button and select "Paste Special".

image

After that, you will be presented with the following options:

image

  • Microsoft Excel sheet (the insertion will take place in the form of a picture, that is, you will no longer be able to edit the table);

image

  • text in RTF format (everything will be inserted unchanged);

image

  • unformatted text (nothing will remain of the table);

image

  • bitmap (you will get the image as in the first paragraph, but its appearance will be much prettier and neater);

image

  • Windows metafile (almost the same picture as in the first case, but with neater borders);

image

  • HTML format (a regular table that can be created with a hypertext markup language, that is, various visual effects from Microsoft Excel will disappear);

image

  • Unicode text.

image

Insert from file

Microsoft Word has the ability to import various files. To do this, go to the "Insert" tab, click on the "Text" button and select the "Object" item.

image

In the window that appears, go to the "Create from file" tab and click on the "Browse" button.

image

After that, specify the file and click on the "Insert" button.

image

The path will be set automatically, click on "OK".

image

As a result of this, you will see the following output.

image

Please note that the table is inserted as an image. Moreover, everything that was above and to the left of it also fell into our document. That is, the insertion occurs from 1 cell to the last one, where there is at least some information.

Also Read:   How To Turn Off Compatibility Mode In Excel

Export a table from Excel

In order to use this option, you need to take the following steps.

  1. Open Excel and click on the "File" tab.

image

  1. In the menu that appears, go to the "Export" section.

image

  1. Here you can:
    • create a PDF file;
    • create a PDF/XPS document;
    • change file type.

image

  1. If you select the last item, you will see the following (you will be offered various document formats).

image

  1. By clicking on the "Save As" button, you can choose even more formats.

image

Possible problems

Sometimes it happens that the user is trying to insert a table that is much wider than the page of the document. In this case, you will see data distortion and the whole design becomes unreadable. Or the right part of the information disappears from the field of view.

image

In this case, you have several options:

  1. Never do that.
  2. Reduce document margins.

To do this, go to the "Home" tab, click on the "Fields" button and select "Narrow".

image

If this is not enough, then try selecting the "Custom fields" item.

image

Reduce these values ​​to 0.5 centimeters.

image

After clicking on the "OK" button, you will see an error that the fields are outside the printable area. Click on "Fix".

image

After that, the Word editor will automatically substitute the desired minimum size. Click the "OK" button to finish.

image

  1. But if that's not enough, there's only one option left. To change the orientation of a document, go to the Layout tab, click on the Orientation button, and select Landscape.

image

Now everything fits perfectly.

image

Conclusion

This article discussed various options for transferring tables from Excel to Word. Please note that for each specific goal there is a ready-made method, that is, the usual key combination [knopka]Ctrl[/knopka]+[knopka]C[/knopka] and [knopka]Ctrl[/knopka]+[knopka] V[/knopka] will not always be the best method.

In addition, some menu items may change depending on what is on the clipboard.

Video instruction

For those who still have any questions, below is a video with additional comments on the above instructions.

Also Read:   How to Delete Blank Rows in Excel
Welcome to BestAnswer.tech, where you can ask questions and receive answers from other members of the community.
...