If the alternate rows are not highlighted even after formatting the table with table style, go to the ‘Table Design’ or ‘Design tab’ (which will only appear if the table is selected) and make sure that the ‘Banded Rows’ checkbox is checked in the Table Style Options group. If you don’t like the current color shading, click the ‘Format as Table’ drop-down again and choose a different table style. In addition to this, it will also make your table dynamic with table functionalities, like sorting, filtering, etc. This will convert the range into a table, apply the selected table format, and color your alternate rows as shown below. Before you click ‘OK’, tick the ‘My table has headers’ option if your data contains headers. If the range is correct, click ‘OK’, if not change the range in the field and click ‘OK’. In the drop-down menu, select any of the formatting styles with banded rows (style with alternate row shading) from Light, Medium, and Dark sections.Īfter selecting the style, a Format As Table dialog will pop up to confirm the range where you want to apply this table formatting. Suppose, you have the below dataset where you want to highlight the alternate rows.įirst, select the range of cells where you want to alternate color rows or any cell in the dataset.įrom the ‘Home’ tab, click the ‘Format as Table’ button in the Styles section. Excel has a large number of built-in table styles or table templates that you can use to achieve this. The easiest and quickest way to highlight every other row in Excel is by applying predefined Excel table styles. Highlight or Shade Alternate Rows using Table Styles If you prefer a more automatic method, try one of the following ways. From the drop-down menu, choose the color of your choice. Hold down the Ctrl key and click on the row numbers on the left-hand side of every other row.Īfter selecting all the rows, go to the ‘Home’ tab and click the arrow next to the ‘Fill Color’ button (paint bucket icon) in the Font Group. The simplest way to highlight or shade color every other row in an Excel table is to manually select rows and fill in them with the color of your choice. Manually Highlight Every Other Row in Excel In this tutorial, we will cover all four methods and more. Shading a different color for every other row or highlighting alternate rows can be done using several different automatic methods, including Conditional formatting, built-in table styles, formulas, and VBA macro. Instead, you can have Excel color alternate rows automatically.
If you were to manually select every other row one by one and add colors to them, it would be time-consuming and tiresome. Highlighting alternate rows help distinguish the different rows from monotonous data and makes it user-friendly. When managing an accounting ledger or a large product list, you may need to highlight or shade alternate rows in your worksheet to make it easier to read and sort data.
HIGHLIGHT EVERY OTHER ROW IN EXCEL HOW TO
Learn how to highlight every other row or column using conditional formatting, built-in table styles, formulas, and VBA macro in Excel.
0 kommentar(er)
