Insert an Excel table with sortable calculations into word.
Open the Word20 10 document, and click? Insert? Label.
Are you online? Form? Click? Form? Button.
Select from the menu? Excel spreadsheet? Orders.
Input data in Excel spreadsheet, and perform operations such as calculation and sorting.
How to insert Excel data table in word2007
If you want to process data like Excel in word2007, you can insert an Excel data table into a word document. The inserted data table has all processing functions of Excel, such as sorting and calculation. The method of inserting an Excel table is as follows:
Step 1, open the word2007 document, and open it in? Insert? Ribbon? Form? Click in the group? Form? Button and select? From the menu that opens. Excel spreadsheet? Command, as shown in figure 1.
Figure 1 click? Form? button
Step 2: After inserting a blank excel spreadsheet into the word2007 document, data processing such as data entry and data calculation can be performed in the excel spreadsheet, and its functions and operation methods are exactly the same as those in excel, as shown in Figure 2.
Figure 2 Inserting excel data table into word2007 document
How to insert a table in word2003
Users who often use office know how to insert tables in word. Now, taking word2003 as an example, I summarize several common methods of inserting tables in word for your reference and study.
Direct insertion method
Open word2003 and select? Form insert form? .
After entering the number of rows and columns, click OK.
At this point, the form has been successfully inserted.
Then enter the data in the table.
First input data method
First of all, in word, enter the data that will become a table, and add spaces to different data.
Box all data.
Click? Form insert form? .
At this point, the table has been successfully inserted.
Insert excel method
Choice? Insert object? .
Choice? Microsoft Excel worksheet? And make sure.
At this time, an Excel table was successfully inserted into word.
Users can edit data as in Excel.
How to insert a table into an existing table in WORD?
Problem description: I want to add two columns of height and weight to the completed resume. What should I do?
Method 1. Draw a table: click Insert, select a table, drop down and select a drawing table. After clicking, the cursor will change into a pencil shape, and you can draw it where you want to add it.
Method two. Splinter cell. Select adjacent rows or columns to add and divide them into two (three) rows or columns.
How to insert tables and add table styles in word?
Click Insert Table, click Table, click AutoFormat, and then select the style you want.
Click? In the menu bar. Form? (Click? Form (a)? ), in the drop-down list, select? Insert? , and then select? Form? A dialog box will pop up, where you can enter table properties (i.e. several columns and rows) and set them according to your own needs.
In addition, you should pay attention to the width of the column when setting, which depends on the demand, that is, the problem of large table or small table.
Problem description:
I want to insert a table with a title in the original document, but the title is always mixed in the original paragraph. What should I do?
Select the title line of the table, table? The title line is repeated = = = = = Hehe, but you didn't make it clear. The above is the effect of making the 1 line or multiple lines in front of the table display at the top of each page when the table is long and needs to be displayed on multiple pages.
If your table is small and you want to arrange it around text, you can insert another row before the first row of the table, select all the cells in that row, and then merge the cells.
Put the title of the table in the merged cell. Then hide the top, left and right borders of this table. To hide a specific border line of a table, you can set it by using the drop-down list button expanded on the right side of the table toolbar, as shown in the figure below.
The pressed state indicates that there is a border line, and the pop-up state indicates that the border line is hidden or different from the current border line setting.
How to make a word list? The simplest method
Manual tabulation method (tables with required size can be made directly)
1. Menu: Table-Draw Table-Drag the mouse to draw the outline of the table.
2. Right-click the box-split the cell (enter the number of rows and columns as required)
Nonstandard form
1. Drag the divider in the ruler to adjust the spacing between rows and columns.
2. Merge cells: select adjacent cells-right click-merge cells.
3. Split Cell: Select a cell-right click-split cell (enter the number of rows and columns).
Guess you like:
1.Word2007 How to create an Excel table
2. How to use rank function to sort in excel?
3.excel whole row data sorting method
4.excel table data sorting method in ascending order
5. How does 5.Excel interlace the payroll?