Excel How To Create Banded Rows

Creating banded rows in a Microsoft Excel table is a great way to make data easier to read and interpret. Banded rows can also be used to help separate and highlight important information. You don’t need to use VBA, Power Query, or manual formatting – you can do it quickly and easily with just a few steps.


Step by Step

First, open your Excel file and select the range of data that you want to apply banded rows to.

Then, click on the “Home” tab and select “Format as Table”. Select the table style that you would like to use and click “OK”.

Note that there are many additional table options! Now that your table is formatted, you can select the “Design” tab at the top of the screen. Explore the “Banded Rows” checkbox, “Banded Columns” checkbox, and other options.

Another great thing about storing your data in a table is that you can also turn on a total row by checking the “Total Row” checkbox. This will allow you to easily calculate the total of all the transactions in your worksheet without having to write a formula.

You can also customize the banded rows by selecting different colors. Just explore the table style gallery.

Banded rows are an easy way to make your data easier to read and analyze. With just a few clicks, you can make your worksheet look more organized and professional, and unlock the power of tables in Excel. Hope it helps!

Sample File

If you’d like to practice, you can download this sample file:

If you have any related tips or suggestions, please share by posting a comment below … thanks!

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.

Leave a Comment