HomeMicrosoft OfficeExcelHow to highlight alternate rows or columns in Microsoft Excel 2016 using Table Style?

How to highlight alternate rows or columns in Microsoft Excel 2016 using Table Style?

In one of the previous blog posts , I explained how the users can use the conditional formatting feature in Microsoft Excel 2016 to highlight alternate rows or columns.

In this blog post , let’s explore the table style feature to highlight alternate rows or columns in excel.

How to highlight alternate rows or columns in Microsoft Excel 2016 using Table Style?

1. Open the workbook in Microsoft Excel 2016 and then select the cells that needs to be formatted.

image

2. Click on the the “Format as Table” dropdown box and select any table format that you like.

image

3. This will display the “Format As Table” dialog. If you already have a header in the selected cells , enable the checkbox “My table has headers” and click OK button.

image

4. With the data selected , you should now see a new tab called “Design” which would be selected and displays additional options. Select the checkbox “Branded Rows” to highlight alternate rows. The Branded Column checkbox can be used to highlight alternate columns.

image

You should see the data with the alternate rows highlighted…

image

    1 Comment

  1. User Avatar
    April 14, 2023
    Reply

    Well, I have already used this one in Excel.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021