When to use Banded Columns in Excel Tables

Banded rows are used by default. But Banded columns need to be selected manually. If you select both, the display becomes cluttered. Here is a situation where using ONLY Banded Columns is useful.

Banded Columns

Look at this data below. It contains lots of text in each column and the text is going beyond the column width. Banded columns make the data more readable by showing the demarcation between where one column ends and where the next one starts! That’s it.

Banded Columns

While we are at it, why don’t you look at all options available under Table tools in Excel.

Queries | Comments | Suggestions | Wish list

Subscribe to Blog

Join 1,749 other subscribers

Popular articles

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Pivot Table Pro Course

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.