The automatic banding continues if you add or delete rows in the table. However, you can apply shading to alternate columns. To do that: To remove shading from rows or columns, under …

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to …

To alternate row or column colors and make tables easier to read, select Design > Banded Rows or Design > Banded Columns. Repeat a table heading on subsequent pages in Word or Outlook

Here's how: Select the range of cells that you want to format. Go to Home > Format as Table. Pick a table style that has alternate row shading. To change the shading from rows to …

Apply a style to format your PivotTable, turn on banded rows to make a lot of data easier to scan, or highlight important information.

You can further adjust the table formatting by choosing Quick Styles options for table elements, such as Header and Total Rows, First and Last Columns, Banded Rows and Columns, as well …

To add special formatting to the first row in a table, select Design > Header Row. To add special formatting to the last row in a table, select Design > Total Row. To alternate row or column …

You can quickly format your worksheet data by applying a predefined table style. However, when you apply a predefined table style, an Excel table is automatically created for the selected data.

To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the …

To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list).