
At last, click OK > OK to close the dialogs, and now, you can find the new table style you are created in Table Styles group, click it to format its style to the active table. Click OK, go on choosing Even banded rows from the Apply formatting to drop down list, and repeat the above step6 to set the border style and fill color as you need. Then, click OK to go back to the Create New Style from Formatting dialog box, this time, please choose Odd banded rows from the Apply formatting to drop down list, and then go to the Borders and Shading dialog box to set the border style and fill color as following screenshot shown:ħ. And then, in the Borders and Shading dialog box, set the border style and fill color from the Borders and Shading tab separately, see screenshot:Ħ. (4.) And then, select Borders and Shading option.ĥ. (3.) Then, click Format button in the left bottom of the dialog box (2.) Select Header row from the Apply formatting to drop down list to set a formatting for the header (1.) Specify a name for this new table style

And then, a Create New Style from Formatting dialog box is popped out, please do the following operations:

In the expanded section, click New Table Style, see screenshot:Ĥ. And then, click More icon from the Table Styles group, see screenshot:ģ. Click a cell in the table that you want to shade rows or columns alternately, and a Table Tools tab is activated, under the Design tab, check Header Row, Banded Rows, Banded Columns options, see screenshot:Ģ. To shade rows or columns alternately in a table of Word document, please do with following steps:ġ. Shade every other row or column in Word table by creating table style
#Alternote tables how to#
It may be a common task for us to shade every other row or column in Excel worksheet, but, have you ever tried to shade rows or columns alternately in a Word table? This article, I will talk about how to solve this job in a Word document table? By implementing the logic through PHP code, we have added an alternate background colour on HTML Table rows.How to shade every other row or column in Word table? In the above file, we have taken two CSS classes, ' even' and ' odd' and defined the background colour. At the top of this page, the ' config.php' file has been added. Here is the main PHP file, ' index.php', that we will call in the browser. $conn = new mysqli('hostname', 'username', 'password', 'databasename') ĭie("Error in DB connection: ".$conn->connect_errno." : ".$conn->connect_error) Make sure to replace ' hostname', ' username', ' password' and ' databasename' with your database credentials and name.
#Alternote tables code#
Now, we have written database connection code to fetch data from MySQL. (4, 'Gaga', This email address is being protected from spambots. (3, 'Priska', This email address is being protected from spambots. (2, 'Smith', This email address is being protected from spambots.

(1, 'John', This email address is being protected from spambots. INSERT INTO `employee` (`emp_id`, `emp_name`, `email`, `phone`, `created_date`, `is_enabled`) VALUES

`created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `emp_id` int(11) NOT NULL AUTO_INCREMENT, Suppose we have the following ' employee' table. In the given example, we are using the PHP programming language to select data from MySQL and display it in a tabular form.
