Site logo white shadow

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,760 other subscribers

Popular articles

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.

Excel to Power BI Course

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