what is the significance of banded rows and banded columns of the table
Answers
When there is a lot of data in an Excel sheet, it is easier for the human eye to distinguish in between the rows and columns when there is color banding. The option for banding rows helps in creating alternating bands of colored or shaded rows and columns.
These colored bands apply a background color to the rows and columns in which they are applied and make it easy for reading and understanding the data in an Excel worksheet when there is a lot of data in many rows and columns.
The feature called List came with many modifications in Excel 2007, among which the most significant one was the Table. Here, a person can create color bands in a table. The banding of the rows and columns can be done according to one’s requirement by using the commands from “Conditional Formatting” option.