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.

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST