Undo excel highlight every other row how to#

Click on the red arrow mark as shown below. Next” we need to select t”e range selection for the table. Now, checkmark the “My table has headers” because our sales data already has headers named SKU, Product title, etc. Here in this example, we will choose “TABEL STYLE – MEDIUM 24”, which shows a combination of dark and light green shown in the screenshot “elow. Click on the format as table down arrow so that we will get the various table styles which are shown below. First, go to the format table option in the Styles group. Now we can apply the banding option using the format table by following the steps below. Consider the below example, which has sales data without formatting.

Undo excel highlight every other row how to#

In this example, we will see how to apply alternate colors to rows using Banding by following the below steps. In Microsoft Excel, applying alternate colors is also called Banding, where we have the option while doing table formatting. We can see that each row has been filled with different alternate row colors in the below result, making the data a perfect view.Įxample #3 – Applying Alternate Row Colors using Banding Once we click the red arrow, we will get the selection range below. Now, checkmark the “My table HAS HEADERS” because our sales data already had SKU headers, Product title, etc.

Once we click on “hat MEDIUM table style, we will get the below format table dialog box which is shown below. Here in this example, we will choose “TABEL STYLE MEDIUM 25”, which shows a combination of dark and light green shown in the screenshot be”ow. Click on the format as table down arrow to get various table styles, as shown below. We can apply alternate colors to the rows by following the below steps as follows:įirst, go to the format table option in the Styles group. Consider the below example where we have some sales data tables with no fill color.Īssume that we must apply alternate colors to the row, making the data more colorful. In this example, we will learn how to apply alternate colors to the row using the data below. Example #2 – Applying Alternate Color to the Rows