In this article, we will introduce 2 methods for you to alternate row or column colors in your Word table.
When it comes to a long table, we always find it pretty tiresome to stare at those numbers and try so hard not to make a mistake. But now, we have 2 awesome ways to deal with such an issue that is to apply different colors for odd and even rows or columns. Following are details:
Method 1: Create a New Table Style
- Firstly, select the entire target table.
- Then, click “Design” tab under “Table Tools”.
- Go to “Table Style Options” group to check options first. For example, we should choose “Header Rows”, “Banded Rows” and “Banded Columns”.
- Next click “More” button in “Table Styles” group.
- And choose “New Table Style” on the drop-down menu.
- Next, in “Creating New Style from Formatting” dialog box, name the new style first.
Note: In the following example, we will demonstrate the way to set different colors for odd and even rows. And the same way can be employed to alter column color.
- Then, choose “Header row” for “Apply formatting to”.
- And click “Format” button on the left down side.
- Choose “Borders and Shading”.
- Now in “Borders and Shading” dialog box, fist click “Borders” to choose whatever setting you need.
- Then click “Shading” and choose a color for “Fill”.
- Next, click “OK”.
- Now you are back to “Creating New Style from Formatting” dialog box, choose “Odd banded rows” for “Apply formatting to”.
- Then repeat from step 7 to 11.
- Again, in “Creating New Style from Formatting” dialog box, this time you choose “Even banded rows”.
- And repeat from step 7 to 11, too.
- Now, you can choose a storage location for the new style, by selecting either “Only in this document” or “New documents based on this template”.
- Lastly, click “OK”.
Now you can find the new style in “Table Styles” gallery. Select the table and choose the style, then you will have it on your table. And when you insert a row into the table, the color of other rows will change accordingly.
For changing column colors, you should choose “Odd banded columns” and “Even banded columns” in “Apply formatting to”. And then take the exact same steps to accomplish your mission.
After colors are set to columns, you may find all table borders missing. Just choose “All Borders” in “Borders”.
Method 2: Insert an Excel Spreadsheet
- To begin with, open Word, and place cursor where the table goes.
- Next, click “Insert” tab.
- Then click “Table” option.
- And on the drop-down menu, choose “Excel Spreadsheet”.
- Now select the entire sheet and make sure that “Home” tab is displayed.
- Then, click “Conditional Formatting”.
- And choose “Manage Rules” option.
- Now in “Conditional Formatting Rules Manager” dialog box, choose “This Worksheet” for “Show formatting rules for”.
- Then choose “New Rule”.
- In dialog box of “New Formatting Rule”, choose “Use a formula to determine which cells to format” for rule type.
- Then enter “=MOD(ROW(),2)=1” in “Format values where this formula is true” text box. This is to format odd rows.
- Next click “Format”.
- The “Format Cells” dialog box will pop up. Click “Border” first to choose necessary borders.
- Then click “Fill”, and choose a background color.
- Next, click “OK” in both “Format Cells” and “New Formatting Rule” dialog boxes.
- Now go back to “Conditional Formatting Rules Manager” dialog box, and repeat step 8, 9, 10.
- Then enter “=MOD(ROW(),2)=0” in “Format values where this formula is true” text box to format even rows.
- And repeat from step 12 to 15.
- Finally, click “OK” in “Conditional Formatting Rules Manager” dialog box.
Still, if you need to alternate column color, you should change the formulas as “=MOD(COLUMN(),2)=1” and “=MOD(COLUMN(),2)=0”.
You can directly edit on Excel sheet or paste a Word table there.
Alter Header Row Color
- Firstly, select header row and repeat step 6, 7, 8.
- Only in “New Formatting Rule” dialog box, you need to choose “Format only unique or duplicate values” for rule type.
- And choose “Unique” for “Format all”.
- Then repeat from step 12 to 15 and step 19.
Comparison of 2 Methods
|Method 1: Create a New Table Style||You can save this table style as a template to use next time.||You can’t set different colors for every 2 rows.|
|Method 2: Insert an Excel Spreadsheet||You can use formula to set colors for whatever cells you select.||You can use the style only once.|
Deal with the Imminent Failure of Computer Program
Users of all kinds of digital devices are aware of the incremental crushes of programs installed. And for many people, we have the possibility of encountering with Word collapse. A damaged word can surely cause a lot trouble. One of the best ways to undermine it is to take routine backups both online and off-site. So you can turn to the latest version even if Word gets corrupted due to accident user errors.
Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including damaged Excel data fix and pdf repair software products. For more information visit www.datanumen.com