How to paste from Excel into Word. Instructions for transferring Excel tabular data to Word
Instructions
Press the "Start" button to open the main operating menu Windows systems and open the “All Programs” section to carry out the procedure for converting the selected table into a text document format.
Open the knot Microsoft Office and launch Excel and Word applications.
Expand the "Table" menu in top panel application window tools and specify the “Convert” command (for Microsoft Word version 2003).
Use the "Table to Text" option in the drop-down menu and apply the checkbox to the desired separator field in the dialog box that opens. It should be remembered that when you select the “Paragraph Mark” option, the data in the table being converted will be separated by paragraphs, and the “Tab Mark” option will allow you to convert the table into a single section. Use the spacebar or hyphen key when selecting the "Other" option.
Confirm that the selected changes are applied by clicking OK (for Microsoft Office version 2003).
Select the ones to be converted into text format rows of the required table, or the entire table, and call its context menu by right-clicking (for Microsoft Office version 2007).
Select the “Layout” item and select the “Data” command in the submenu that opens.
Use the "Convert to Text" option and apply the checkbox to the desired separator field in the dialog box that opens. Confirm the application of the selected changes by clicking OK (for Microsoft Word version 2007).
Select the selected table and expand the "Edit" menu in the top toolbar of the Excel 2010 application window.
Specify the "Copy" command to save the table to the clipboard and go to Word application.
Select a location to save the text document you are creating and open the “Edit” menu in the top toolbar of Word 2010.
Select “Paste Special” and use the “Sheet” option Microsoft Excel(object)".
Confirm that the selected changes are applied by clicking OK (for Microsoft Office version 2010).
Sources:
- How to copy an Excel table to Word
When working with text documents, sometimes there is a need to translate them from one format to another - for example, *.doc to *.pdf or *.html. Knowing how to do this allows you to use your time to work rather than search necessary programs and methods for converting texts.
Instructions
You can convert the *.doc format to *.html using standard means text editor Microsoft Word. Select from the menu: “File – Save as web page”. In the window that opens, select the required document type - *.htm or *.html. Click the "Save" button. You can view the page code by opening it in a browser and selecting the “View HTML code” option.
Despite the speed and simplicity of the method described above, the resulting code contains too many unnecessary tags, which increase the file size. The code will be cleaner if you use a text editor not from Microsoft Office 2007 or 2010, but from the now almost obsolete Microsoft Office-97.
You can clean the code using HTML Cleaner. Working with it is very simple: open the program and select the desired html file. The program will clean it of debris, and as a result you will get a very high-quality html code.
You can convert *.doc to *.html using Adobe programs Dreamweaver. This program allows you to create website pages in a visual mode; it has the option of translating a *.doc file into *.html and cleaning it.
Converts *.doc to * quite well. html program Microsoft Office FrontPage 2003. Other versions of this program may require manual code editing.
A good result when translating *.doc to *.html is Total program Doc Converter. It has many settings and allows you to translate text file at the most different formats.
If you need to convert a text file into *.pdf format, use Microsoft Office version 2007 and higher or the freely distributed office suite OpenOffice.org. ABBYY PDF Transformer also copes with this task very well. The advantage of this program is that with its help you can not only create a PDF file from a doc file, but also perform the opposite operation - convert any PDF document into a text file.
To work with tables in text editor Microsoft Office Word you need to master the tools built into the program. The application interface is intuitive, however, a novice user may have a number of questions about how to design a table, separate cells or make borders invisible.
Instructions
Run Microsoft editor Office Word and create new document(or open an existing file). Create a table. To do this, go to the “Insert” tab and in the “Tables” section, click on the “Table” thumbnail button. Set the number of rows and columns future table using the built-in layout or select the Draw Table command.
When your document contains at least one cell created with tools from the Tables section, the Tools with Tables context menu becomes available. To open it, position the mouse cursor in any cell of your table. It is in context menu you will find tools for deleting or adding new rows and columns, for adjusting the direction of text inside cells, for editing the appearance of borders.
If you need to format a document in the form of , located parallel to each other, do not create, it is better to format one correctly. The easiest way to divide a ready-made table is to use the Borders tool. This method will save you from the need to “adjust” the height of the cells.
You can find the specified tool in two toolbars. The first panel is located on the Home tab in the Paragraph section. The second is in the “Working with Tables” context menu on the “Design” tab in the “Table Styles” section.
Add an additional column that will split the table into two parts. Select it and click on the “Borders” button (it looks like a square divided into equal parts). From the drop-down menu, select the option where some of the edges will not be drawn completely by clicking on it with the left mouse button.
After this, part of the column edges will be displayed as lines gray. They serve only so that you can work with them in electronic document. These gray edges are not printed, so the effect of two tables located parallel to each other, separated by a space, is created.
Speech-to-text conversion programs have existed for a long time, but their development in Russia has hardly budged since the 90s. This is due to the fact that in our country there are quite a few specialists working in this area.
You will need
- - speech recognition program.
Instructions
Buy a microphone with good sound sensitivity. If your computer already has a built-in microphone, it is possible that it may not be enough for speech recognition and its further translation into . There are a lot of speech conversion programs, but they are all demanding on the equipment used, especially for Russian speech. It is also necessary that your sound card is best suited for speech perception.
Download a voice-to-print program speech. Most of these utilities work on a paid basis, and if you need a program that converts Russian speech, try using “Dictograph” or “Gorynych”. These are one of the few programs that can recognize Russian speech for further conversion into text new form in more or less acceptable quality. In addition, they practically do not load the system, having minimum requirements to the computer configuration. Their big disadvantage is their relatively small vocabulary. Compared to foreign analogues, recognizing, for example, English speech, domestic developers are still at entry level. In case you need to recognize English speech, you will have much more choice.
Install the program on your computer after purchasing it; register, if necessary, familiarize yourself with its interface; if possible, download updates. After that, connect the microphone, in the “Sounds and Audio Devices” menu of the control panel, configure the equipment, in the parameters sound card disable additional effects.
Video on the topic
Please note
Please note that when using a standard microphone there is less chance of good results speech recognition rather than using separate device.
Microsoft Word offers its users a very convenient option that allows you to translate typed text. text. You no longer need to dig through dictionaries looking for word translations or use translator programs. All you need to do is launch Word.
You will need
- - computer;
- - Internet.
Instructions
Launch Microsoft Word on your computer. The version of this program must be at least 2003.
Type the text that requires translation, checking it for spelling errors. Any inaccuracy may make the text difficult for the program or distort its meaning. Select the text you have typed and click the “Review” tab in the main menu. In the menu that opens, select “Translation”. After this, the “Reference Materials” window will appear to the left of the page.
You can open this window in a simpler way. Select the text or required fragment, right-click on it, and select “Translation” from the context menu that appears.
In the window that opens, specify the source language and the target language. After this, the program will display the translated text below. You can also set certain translation parameters by clicking on the inscription of the same name in the “Reference Materials”. In the window that appears, check the box next to “Use a dictionary on the Internet.” This will contribute to a more perfect translation.
After required text translated, click the “Insert” button below it. And in your document, text in a different language will appear in place of the original test.
If there is no such button, simply select the translation, right-click on it, and select “Copy”. And then paste it in place of the original text. The translation will be completed.
You can translate not the entire text, but a specific fragment or word. To do this, select the element that requires translation and apply all the actions described above to it.
Remember that when translating, the computer conveys only the general meaning of the sentences. Therefore, you should not use translated text in business documents or correspondence.
Please note
To translate text into Word, your computer must be connected to the Internet. This is where the data for translation is taken from.
Sources:
- how to translate text from a photo into Word
IN Microsoft application Office Excel It is possible to hide columns and tables. This can be convenient in cases where it is necessary to increase the visibility of complex tables by displaying only the most important data, or to hide the display confidential information.
Instructions
When you're swerving lines, the corresponding headings also disappear, therefore, anyone who opens an Excel workbook will easily guess that if after lines 3 goes to line 5, which means line 4 is hidden. Take this into account when formatting the data on the sheet.
To collapse lines, move the mouse cursor to the column with the names of the lines on the left side of the window. Left-click on the line from which the selection will begin. While holding it down, move the cursor to the line that ends the selection. Release the mouse button.
If lines are not adjacent, press the Ctrl key on your keyboard and, while holding it down, use the mouse to mark the ones you need lines. In this mode, do not use the mouse wheel to move around the sheet, since the Ctrl key is also responsible for the page scale. Use the scroll bar. If you still want to move around the sheet using the mouse, release while scrolling hotkey.
Having selected the desired range, right-click on the selection. In the context menu, select the “Hide” command by left-clicking on it. Selected lines will be rolled up. To perform this task, you can also use the buttons on standard panel tools.
Highlight lines that you want to collapse, and open the Home tab. On the toolbar, find the Cells block. Click on the "Format" button. In the drop-down menu, select the “Visibility” group and the “Hide or Show” option. A submenu will open. Select the command “Hide” lines».
To return display to collapsed rows, select two adjacent lines, between which the data is hidden, and right-click on the selection. From the context menu, select the “Display” command. Another option: select not lines, and cells that meet the specified conditions. On the toolbar in the "Format" menu, call the "Display" command. lines" from the "Hide or Show" group.
Often mathematical data processing requires performing rather complex operations on entire arrays. In most cases, it does not matter to the program whether the values of the variables are written in columns or rows - required parameters can be specified in formulas. But if you need to perform some actions with the entire matrix, you should take into account that the task can only be performed correctly if the variables are located in columns.
Instructions
However, this situation most often occurs when conducting multidimensional statistical analysis when using the Analysis Package add-on. Usually the matrix needs to be “rotated” just for convenience further work. In both cases, the matrix must be reflected, or . Then the rows will be “inverted” into columns.
To transpose, simply select the required matrix with the cursor and copy it to the clipboard using the keyboard shortcut Ctrl+C, Ctrl+Insert, or selecting “Copy” from the “Edit” menu. Place the cursor in cell A1 if you are going to place the transposed matrix on a new sheet. In the same way, you can insert a transposed matrix into the original sheet, removing the original data. Placing the transformed matrix on the same sheet while preserving the old one is not very convenient and is only advisable for small arrays.
Then, from the Edit menu, select Paste Special. A “Paste Special” window will open in front of you, where you can specify various additional options. In the very last block of functions there will be two checkboxes: “skip empty cells” and “transpose”. Check the last box. If variable values are entered manually, simply click OK to complete the operation. This will be enough to correctly reflect the original matrix.
If the values in the array are the result of calculations using some formulas, for correct transposition you will need to specify additional parameters in the “Paste Special” window from the “paste” group of commands. If you no longer need the original formulas, select "Values" or "Values and Formats." The latter is selected when it is necessary to preserve the original cell format.
When choosing one or another method of inserting while saving formulas, you will have to take into account the version of your Office. Starting from the tenth version of Office, including MS Excel 2002, formulas can be transposed without taking into account the automatic “sliding” of variables: the program will independently take this factor into account and display the values correctly. If you are using an older application, when transposing formulas, the values may change beyond recognition, resulting in you getting a matrix completely different from the original one.
Software Microsoft packages Office Excel, Gnumeric and OpenOffice.org Calc allow you not only to create and edit spreadsheets, but also to perform calculations. You can, for example, enter the birth years of the people listed and automatically calculate them age.
Instructions
Allocate one cell in the table for the current year number. Enter the appropriate number there (be sure to be a four-digit number, not an abbreviated two-digit number). In all of the examples below, the current year number will be assumed to be entered in cell A1.
You can also set the current year to be set automatically. Then the value of the corresponding cell will not have to be manually modified annually, but the calculations will be carried out correctly only if the computer clock is set correctly. Use the following formula for this: =year(today()) in the Russian version or =year(today()) in the English version. In the Gnumeric program hereinafter, use operators on English, even if the program interface itself is Russified.
In the cell that should contain the person's age, enter the following expression: =A1-Xn, where Xn is the cell that contains the year of birth of the same person. For example, if it is located in cell B4, then the expression will look like: =A1-B4.
This method is inconvenient because the birth dates of all people listed in the table are taken as the first of January, and the age is calculated without taking into account the fact that birthdays may fall in the middle or end of the year. To calculate age more accurately, place the current date in cell A1 in the format that the office package you are using is configured for (these settings can be changed). For example, if the date format is dd/mm/yyyy and today is April 6, 2012, enter 04/06/2012 in this cell. Please note that in this case you will have to change the contents of this cell manually every day. To avoid this, enter the expression: =today() or =today(). In this case, as in the previous case, make sure that the clock and calendar are set correctly on the computer.
Instead of the person's year of birth, enter his date of birth in the appropriate cell in the format for which the office package is configured. And in the cell in which the automatically calculated age should be indicated, enter the following expression: =datedif(A1;Xn;"y") or =datedat(A1;Xn;"y"). For example: =datedif(A1;B4;"y"). The letter y is Latin in both cases.
Having heard that the ship was sailing at a speed of 10 knots, people unfamiliar with maritime affairs are forced to clarify whether this is a lot or a little, good or bad. Marine terminology for the uninitiated is in most cases quite complex, but there is nothing complicated with the conversion of knots into familiar ones into hours and vice versa.
Instructions
A nautical mile is equal to 1852 meters. This distance corresponds to one geographic minute of arc, that is, one sixtieth of a degree. Accordingly, 60 nautical miles along the meridian will be one degree of latitude, and walking along this meridian at a speed of one knot will travel in an hour and 1 arc minute. For navigation it turned out to be very convenient to use this method of measuring distances, so the knot and mile are still widely used at sea and.
To convert kilometers per hour to knots, you need to multiply the speed by 0.54. The result obtained will be the speed in knots or nautical miles per hour. To recalculate the speed in knots you need to multiply by 1.852, the result is kilometers per hour. Although the nautical mile is not included in international system units, its use, and therefore the use of nodes, is completely acceptable.
In order not to remember the rather complex ratios of knots, nautical miles and traditional kilometers, for conversion you can use one of the many -converters (unit conversion calculators) that will help you quickly convert one value to another.
Please note
A knot is a unit of speed in its own right, and saying “knots per hour” is incorrect.
Sources:
- Online conversion of speed units
- how to convert speed
Sometimes, after creating a table, you need to edit it: add or remove columns and rows, highlight cells, change the font... MS Word offers many ways to work with tables.
How to highlight table elements
To edit, you must select the entire table or its individual elements. It is most convenient to select adjacent elements with the mouse. Place the cursor in in the right place, press left button and drag the mouse in a horizontal or vertical direction. If you need to edit cells, columns or rows that do not border each other, select one group of elements with the mouse, hold down the Ctrl key and select another group..
To select an individual column or row, place the cursor in one of the cells that belong to it. In the “Table” menu, in the “Select” section, click on the desired item. In the same way, you can select the entire table or a single cell.
If you're using Word 2010, in the Table Tools group, go to the Table Layout tab and click the Table icon. Under Select, select Quick selection groups of cells."
How to add rows, columns and cells
IN Word versions 2003, use the cursor to mark the cell next to which a new row, column, or cell should appear. In the "Table" menu, in the "Insert" group, specify the desired element and insertion method.
In Word 2010, right-click on the desired cell and select “Insert” from the context menu.
How to delete a table and its elements
Use your mouse to select the elements you want to delete or the entire table. If you are using Word 2003, in the "Table" menu, in the "Delete" group, select the desired command. To delete an entire table, click on “Select” in the “Table” menu.
In Word 2010, the Delete button is located in the Layout tab in the Table Tools section. Specify the item and how to remove it.
If you need to delete the contents of a table, select it with the mouse and click Delete. Rows, columns and cells are cleared in the same way.
How to change column width and row height
Hover over the border of the column or row that you want to resize. When the pointer looks like two arrows pointing towards different sides, hold down the left button and drag the border with the mouse in the desired direction.
Working with cells
If you want to split a single cell into columns and rows, right-click on it. In Word 2003, use the Split Cells command and specify the right number columns and rows. In Word 2010, the Split Cells command performs this task.
If you need to merge several cells into one, select adjacent cells with the mouse, right-click on them and select the “Merge Cells” command from the context menu.
You can choose horizontal or vertical placement of text in a cell. Right-click the cell, then click "Text Direction" in the drop-down menu. In the Orientation section of the direction window, specify the desired location.
Tip 11: As in Excel spreadsheet automatically sort last names alphabetically
Ms Excel is a powerful spreadsheet editor. It allows you to work with voluminous data types, namely, sort them according to a given criterion, set the necessary formulas, and much more.
Sorting by specified filter
One of the important and required functions Ms Excel program is automatic sorting by given parameter. This function allows you to organize data in a Ms Excel table. You can sort the data various types: text, such as last names, and numeric, such as dates. There are at least two types of sorting.
To arrange surnames alphabetically, you must select sorting by one attribute. It is worth saying that surnames in Ms Excel can be systematized in ascending order, that is, from “A” to “Z,” or vice versa, in descending order. This is the so-called simple sort.
With this type of sorting, it is enough to select the column in which the names to be sorted are located. Then, in the Ms Excel control panel, at the top right, find the Sort and Filter option. Click on it with the left mouse button, a window will open in front of you in which you can choose to sort from the first letter of the alphabet to the last, in reverse order, or independently determine the required parameter. Simple sorting is suitable if there is only one column with last names in the Ms Excel document.
If your document has many columns, then Ms Excel may ask you to clarify whether or not to expand the formatting area. In this regard, a corresponding dialog box will appear. You can choose to expand the range or sort according to the highlighted value. When you select Auto Extend Formatting, cells associated with the formatting column will still remain anchored to it. Otherwise, sorting will not affect them. At this moment, you should be careful, because the data in the document, if sorted incorrectly, risks getting mixed up.
Custom sorting
The user can use another way to sort surnames alphabetically by selecting a custom range. In this case, you will have to independently specify the column by which the data will be ordered. The actions of the user of the Ms Excel program will be the same, only you should select the “Custom sorting” option in the “Sorting and Filter” section. The user then selects the column by which the data should be sorted. IN in this case This is the column with last names. The next step is to choose to sort alphabetically from the first letter to the last or vice versa. This kind of sorting is usually called complex.
Remember that in Excel you can sort any column, regardless of its location on the worksheet. Depending on what version of Ms Excel you have installed, the settings automatic sorting may vary, but the essence of the work remains unchanged.
Microsoft currently provides a wide range of software Microsoft Office, which aims to introduce operating system convenient editors that allow you to work with both text and tabular data. The most common programs office suite are Excel and Word. A more suitable editor for working with tabular data is Excel, but creating a table in Word is also very simple and not particularly difficult for any user.
Instructions
IN Microsoft versions In Word 2010, there are several ways to create tables. The most common is to use a template provided by the program. It is enough to enter the initial parameters for the width of the cells, decide on the number of required columns and the number of rows, after which the program automatically creates the desired table, which can be placed in any part of the document. The command to insert a table is on the panel quick access and in the "Insert" menu. Clicking on the table icon automatically launches the table editor algorithm, which creates a layout step by step by analyzing the user-entered source data. Even a novice user can create a table in Word in this way. In case of errors or inaccuracies during the introduction basic parameters template forms can be adjusted and edited. The user can add or remove rows and columns at any time, as well as change their width and height, and set the direction of the text.
The “Insert Table” submenu also includes a second more quick method its creation, based on the function of selecting squares with the cursor, which represent the projection of the cells of the future table. Having a visual idea of the required structure, the user can easily command the program to create the desired layout. The created table can be easily changed during the filling process. The disadvantage of this method is that the template provided by the program is limited in the number of rows and columns. Maximum size automatically created table - 10 by 8, after which, if necessary, you can add or remove rows and columns manually. This method is most often used when creating simple small tables, since it does not require special knowledge and skills in working in Word.
More advanced users can create a table in Word using other programs. Using the “Insert Excel Table” submenu, an automatic link to the table editor is added to the Word document, and the work in the window that opens is editing data with Excel. Excel's method of creating tabular data makes it easier for the user to fill them out, since the program provides the ability to use formulas and automatic calculations applied to each cell. In addition, nested tables have a much better visual display, and also include the function of automatically constructing charts based on tabular data, which is important for analytical work.
Much less often, Express Tables are used to create nested Excel tables. This function designed for experienced users due to its complexity. However, if used skillfully, you can do more than just quickly create tables required format, but also to use in them the functions of automatic display of the most complex mathematical formulas and tasks. A convenient designer and a wide selection of layouts allow you to create a table in Word of any orientation. It is almost impossible to achieve such results using conventional templates and the built-in table drawing function.
It should be noted that the method of drawing tables is the least convenient due to the imperfect Word drawing panel. Therefore, the method of creating tables using a virtual pencil is used extremely rarely. They resort to him in exceptional cases when you need to add individual lines or complicate the structure of an already created table. Thus, there are many ways to create a table in Word. All of them are designed for different categories of users, from a beginner who has just become acquainted with Microsoft Word to a specialist who knows all the intricacies of this program.
Video on the topic
Today everyone knows that Microsoft Excel is the best and most convenient multifunctional program for working with tables. 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 manual, we will tell you how to transfer a table from Excel to Word and look at several basic methods for doing this.
So let's get down to business.
- First, let's create some table in Excel.
- Now you need to select the entire table.
Copying by table
After this we have three options:
- Click on hot Ctrl keys+C or right-click and select “Copy” from the context menu.
- Click on the “Copy” icon on the main toolbar.
In all the methods described above, we will copy the object while preserving the table properties. That is, we will be able to edit this table in the future after we insert it into a Word document.
Copy as drawing
But if in the third method you press not the button, but the “triangle” next to it, you can see additional menu. You need to select the second item.
Paste in Word
It doesn’t matter in what format you copied the contents of the table, you can transfer it all into a document in the following ways:
- Click on the hotkeys Ctrl +V. As a result of this you will see the following.
In this case, all functions for changing the content and format of data will be available.
- Open the Word editor and click on the “Insert” button on the main toolbar.
As a result, the table will be inserted automatically.
But if you click on the button instead of the “triangle” underneath it, you’ll see several different options.
Let's take a closer look at them (when you hover over each icon you will be able to preview):
- preserving the original formatting;
- use end fragment styles;
- link and preserve original formatting;
- link and use final styles;
- drawing;
- save text only.
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”.
You will then be presented with the following options:
- 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);
- text in RTF format (everything will be inserted unchanged);
- unformatted text (nothing will remain from the table);
- bitmap (you will get the same image as in the first point, but its appearance it will be much more beautiful and neat);
- Windows metafile (almost the same picture as in the first case, but with neater borders);
- HTML format (a regular table that can be created in hypertext markup, that is, different visual effects will disappear from Microsoft Excel);
- Unicode text.
Inserting from a file
Microsoft Word allows you to import various files. To do this, go to the “Insert” tab, click on the “Text” button and select the “Object” item.
In the window that appears, go to the “Create from file” tab and click on the “Browse” button.
After that, specify the file and click on the “Insert” button.
The path will be entered automatically, click on “OK”.
As a result of this, you will see the following result.
Please note that the table has been inserted as a picture. Moreover, everything that was above and to the left of it also ended up in our document. That is, the insertion occurs from 1 cell to the last one, where there is at least some information.
Exporting a table from Excel
To use this option, you need to take the following steps.
- Open Excel and click on the "File" tab.
- In the menu that appears, go to the “Export” section.
- Here you can:
- create a PDF file;
- create a PDF/XPS document;
- change file type.
- If you select the last item, you will see the following (you will be prompted various formats documents).
- When you click on the "Save As" button, you can select more more formats.
Possible problems
Sometimes it happens that the user tries to insert a table that is much wider than the document page. In this case, you will see data distortion and the entire design will become unreadable. Or right side information disappears from visibility.
In this case, you have several options:
- Never do that.
- Reduce document margins.
To do this, go to the “Home” tab, click on the “Margins” button and select “Narrow”.
If this is not enough, then try selecting “Custom Fields”.
Reduce these values to 0.5 centimeters.
After clicking the “OK” button, you will see an error stating that the fields are outside the printable area. Click on "Fix".
After this, the Word editor will automatically set the required minimum size. To finish, click on the “OK” button.
- But if this is not enough, there is only one option left. In order to change the orientation of the document, you need to go to the “Layout” tab, click on the “Orientation” button and select “Landscape”.
Now everything fits perfectly.
Conclusion
This article discussed various options for transferring tables from Excel programs into the Word editor. Please note that for each specific purpose there is a ready-made method, that is, the usual key combination Ctrl + C and Ctrl + V will not always be the most optimal method.
Additionally, some menu items may change depending on what's on your clipboard.
Video instructions
For those who have any questions, below is a video with additional comments on the instructions described above.
Sometimes we need to insert an Excel table into a Word document. In this case, the inserted table should be updated automatically. In other words, after making changes to an Excel table, the inserted table in Word should update automatically without updating the Word document itself. This can be done in several ways - by linking objects and creating a new Excel table inside a Word document. Typically, most of us do not use these methods. They use regular copy-paste. You can, of course, simply copy the Excel table and paste it into Word, but then it will not automatically update.
Method 1: Copy and Paste Excel sheet in Word
Simply copy the contents of the Excel sheet and paste it into a Word document. Select the paste option as “preserve source formatting and link to excel” or “use destination table style and link to Excel”.
Essentially we are inserting static Excel data in Word. If you refresh an Excel table, the changes will not appear in Word. If you change an Excel sheet and then open a word document, it will ask if you want to update the document. If you click yes, Word will update with the latest changes.
If you use this method and want to update the corresponding Word document, simply right-click on the Excel data in Word and select "Update Links"
If you right-click on Excel data in Word and select the menu item "Linked Object/Sheet" -> "Edit Link" an Excel form will open in which you can make changes without directly opening Excel file. Once you have made the necessary changes, save the form and the data in the Word document will also be updated.
Method 2: Using Object Insertion
The second method links an Excel sheet to a Word document through object insertion.
Step 1: In Word, on the Insert tab, in the Text box, click the Object insert.
Step 2: Select “Object” in the dialog box and go to the “Create from File” tab. Select the “Link to file” checkbox, specify the Excel file to be linked using the standard Windows Explorer and click "OK".
The Excel file is inserted. If you double-click on Excel data, the original Excel sheet will open. You can make any changes to it just as if you had opened a regular Excel file. This method allows you to automatically change data in a Word document when you change the same data in Excel.
Method 3: Using the Insert Table command
IN this method We create a new Excel sheet in a Word document. In Word, click on the Insert tab -> Tables. Select "Table in Excel".
The Excel sheet is inserted. Now you can create formulas, use filters, etc. Those. work as in a regular Excel document.
This option Excel inserts it may turn out useful topics who wants to work with Excel in Word as with regular Word tables.
When copying tables from Excel to Word, as well as when transferring cell values from Excel tables to Word tables, various troubles may arise in the form of mismatched formats, sizes, and simply incorrect insertion of copied data. To efficiently transfer data from Excel to Word, you need to know a few things.
How to transfer a sheet from a bookExcel to documentWord?
To transfer data from an entire worksheet to a Word document Excel workbooks, you need to go to the “Insert” tab and in the “Text” button group click the “Object” button. On the Create from File tab of the Insert Object dialog box,
Using the “Browse” button, you need to find the workbook with the data to be transferred. It is worth noting that the active sheet in the workbook must be the one that contains the data to be transferred to the Word document. This inserts file data into a document so that it can be edited using the application in which it was created. In other words, an Excel application area appears in the Word document, which is activated double click left mouse button. This replaces the Word ribbon with the Excel ribbon, and you can make changes in this area of the Word document using Excel tools.
In the Insert Object dialog box, if you select the File Link check box, the Word document will display automatic mode changes made to the source file.
How to transfer a table or range of cells from Excel to Word?
To move a table or any arbitrary range of cells with data from workbook Excel to Word document, required in Excel application copy a range of cells, go to the Word application and on the "Home" tab in the "Clipboard" button group, expand the "Paste" button menu and select one of the available paste options, such as, keep source formatting, use destination styles, save as picture , save only text and some others.
Except listed options The “Paste Special” item is available, with which you can paste the copied table or range as an object, as well as select other paste options.
How to selectively transfer data fromExcel toWord (automatically)?
In some cases, when there is a need to fill individual rows/columns of a table in a Word document with data from Excel, the Word add-in for automatic completion will help you avoid performing multiple “Copy/Paste” actions Word tables data from Excel.
For example, when filling out specifications for project documentation, you need to selectively transfer information from the Excel workbook database to a Word document. In this case, you do not need to transfer the entire Excel table, but only some of its rows, despite the fact that they are not located in the same range, which could be copied and pasted in one action. The add-in allows you to automate the process of selectively transferring data from an Excel table to a Word table.
After selecting the Excel workbook (database) and the worksheet containing the data to transfer to the table in the Word document, the dialog box displays the cell values from the first two columns of the database worksheet. The user can regulate the number of displayed columns independently by changing the numbers of the first and last column. Depending on this, the contents of the dialog box change. The first row of the database file worksheet serves as headings for the columns in the dialog box. In order to transfer data from the dialog box, you need to select the desired lines using the left mouse button and the Ctrl and/or Shift keys on the keyboard.
After starting the program, the values of all the lines selected in the dialog box are transferred to the table cells of the Word document, starting from the cell in which the mouse cursor is located. The add-in allows you to selectively fill tables in Word editor data from Excel. An example of using this add-in is filling out specifications of equipment and materials for project documentation, when in order to fill out documents by section it is necessary to selectively transfer data from databases created on the basis of Excel workbooks to a table in a Word document.
For users using widescreen monitors, it is possible to resize the dialog box to fit the width of the Word application window.
How to transfer individual values fromExcel toWord?
To autofill Word documents with data from Excel, you can use ready-made solutions(add-ins) for both Word and Excel. These solutions allow you to automatically generate Word documents based on data contained in an Excel workbook sheet. These solutions provide the ability to batch fill out documents (for cases when, based on one set of initial data, you need to fill out several different documents, for example, a contract, additional agreement, power of attorney, and so on).
Task table transfer from Excel to Word occurs when a large volume is compiled text document, containing tables that require calculations. Examples include coursework, dissertations, and dissertation texts. This article is addressed to everyone who has encountered such a problem.
Several subtasks can be distinguished:
- transfer the table with the loss of formulas and, accordingly, the possibility of recalculation when data changes, but with the ability to change the font, borders and other formatting parameters;
- move the table as a graphic object (drawing);
- move the table, leaving a connection with the program where it was created, and, accordingly, the ability to change the calculation results;
- transfer only text from cells.
In the first case, your actions are as follows:
- highlight original table V Excel;
- copy it in any way acceptable to you;
- in the window Word specify the location of the new table location, call the command Insert(button on the tab Home or team in context menu) and select the first or second option in Paste options(the results of both options are visible in the figure). If you use hotkeys to paste ( CTRL+ V), then the insertion will be performed with the first option of insertion parameters, and a button for selecting parameters appears next to the inserted table.
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681933_2.jpg)
In the second case, when inserting, select the penultimate option in Paste options.
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681977_3.jpg)
After that, you can do everything with the table that you can do with the picture (rotate, resize, etc.).
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681994_4.jpg)
In the third case, when inserting, select the options indicated by the ¥ icon (there are two of them, the only difference is in the design of the inserted tables).
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471682004_5.jpg)
You can evaluate the merits of such insertion methods if you change the data in the source table, then in another, related one, select in the context menu Update connection.
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681977_6.jpg)
In this case, the values in the table cells will automatically change in accordance with the current values in the Excel file.
In the fourth case, select the last option Paste options. The result will be structured text without a table.
![](https://i0.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681918_7.jpg)
In addition to the ones discussed, there are several more options Special insert tables created in Excel. In this article we will consider one of them. If in the Paste Special selection window you stop at the first command ( SheetExcel) with parameter Insert, then the user will have the opportunity to double click using the table, switch to the value editing mode (nothing changes in the original Excel table).
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681996_8.jpg)
Moreover, you can even edit personal or hidden data. This feature appears when you use Document inspector, which is launched by the command Troubleshooting on the tab File. Such data may exist in your table regardless of whether you took steps to create it yourself (for example, authorship information, printer paths, and some others). Access to To the document inspector available in versions Microsoft programs Office after 2013.
![](https://i1.wp.com/microsoft-help.ru/uploads/posts/2016-08/medium/1471681940_9.jpg)
By learning how to transfer tables from Excel to Word, you can not only organize your work rationally, but also protect your data.