Word 2007 table odd and even staggered coloring easy to implement

When you enter a large amount of data in Excel tables, it is customary for the input to fill different colors to prevent the viewer from seeing the wrong line. But to interlace the odd and even rows of a data table in Word, the process is quite tedious.!dafan to show us the specific steps, you can refer to the "Rapid implementation of Excel, Word form odd and even staggered coloring" article (URL) However, if it happens to be Word 2007, the situation is another matter! Word 2007 can easily insert Excel tables, so it is no longer difficult to interlace the odd and even rows of a Word 2007 table:

The first step--insert an Excel spreadsheet: Open or create a new document in Word 2007 that will be inserted into the table, click on the menu bar "Insert" → "form" → "Excel spreadsheet", and then insert a form that is not the same as the normal Excel document. You can add a table's visible rows or columns by dragging the mouse (Figure 1). Double-click to select it to edit an Excel table (for example, you can add more than one workbook, but when it is saved as a Word document, only the contents of the currently open workbook are displayed, but you can double-click the table to see all the workbook contents);

Figure 1 Drag-and-drop method to increase the table's visible rows or columns

Step two--coloring a table with even rows: Switch to the Start tab of Word 2007, select the workbook, click conditional formatting → manage rules, and then, in the Conditional Formatting Rule Manager window that appears, click New Rule, and select the type of cell to use formula to determine the format to set , in the format for values that fit this formula, enter: =mod (ROW (), 2) =0 (Figure 2), and click the Format button to set the fill color and border color;

Figure 2 Input: =mod (ROW (), 2) =0

Step three--the odd line coloring of the table: in the second step, enter the formula: =mod (ROW (), 2) = 0, and set different "fill" colors and the same "border" color.

Look, is this process a lot simpler? As you can see, because Word 2007 can easily insert Excel tables, with the help of the function of Excel tables, it is easy to implement the staggered coloring of the table's odd and even rows, which is indeed a bit of a "sham-guo" meaning! See the real chapter in detail, it seems that word 2007 of the function is still more powerful than Word 2003 Ah!

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join