Quite often, there is a need to transfer tabular data from Microsoft Word to a sheet of a Microsoft Excel spreadsheet. The table can be copied, but several commands must be executed to display the information correctly.
It is necessary
- - A computer;
- - installed Microsoft Office package.
Instructions
Step 1
Open the document created in Microsoft Word from which you want to transfer the table to Microsoft Excel. Click on the table with the left mouse button, select the command "Table" - "Select Table" from the menu.
Step 2
Press the key combination Ctrl + C (or the menu item "Edit" - "Copy"; the button on the toolbar). Next, go to the worksheet of the workbook in Microsoft Excel, select the place where the upper left cell of the table will be located, press Ctrl + V to copy the Word table to Excel.
Step 3
Make sure that the area where you want to copy the table in Excel is empty, as the data from Word will replace all existing information in the cells of the worksheet that are in the insertion area. Check the dimensions of the inserted table. Then click the "Insert" button.
Step 4
To correct the formatting of the table, click the Paste Options button that appears next to the pasted information. If you want to use the formatting that is applied to the cells in the worksheet, click the Use Destination Cell Formats option. If you want to keep the original table formatting, then click on the "Keep original formatting" option.
Step 5
Edit the resulting table if the table elements were separated by tabs or spaces. To do this, select the table, go to the Data menu, select the Text by Columns command there.
Step 6
Select the Delimited option, click Next. Select the desired character (space or tab) as a separator, click the "Finish" button. Sometimes, after inserting data, you need to clear the data in order to be able to use the data calculation function in Excel. For example, unnecessary spaces may appear in cells, numbers may be inserted in text format rather than numeric. It may also result in incorrect display of dates. To fix this, select the data in the same format, right-click and select Format Cells. In the "Number" tab, set the required data format (numeric, currency, date, etc.).
