Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

You can also apply emphasized formatting to the first or last column of the table. For all Table Styles, bolding is applied to the entries in the first or last column of the table when these options are enabled. For some styles in the Medium and Dark sections of the Table Style gallery, the color of the Header Row is also applied to the column.

You can also hide or redisplay the Header Row.

Changing table style options



P ROCEDURES

1. Select a cell in the table. 2. Select the Design tab. 3. To enable or disable the display of data rows in alternating colors, select or deselect the Banded Rows option in the Table Style Options group. 4. To enable or disable the display of data columns in alternating colors, select or deselect the Banded Columns option in the Table Style Options group. 5. To enable or disable emphasized formatting for the first table column, select or deselect the First Column option in the Table Style Options group. 6. To enable or disable emphasized formatting for the last table column, select or deselect the Last Column option in the Table Style Options group. 7. To hide or redisplay the header row, deselect or select the Header Row option in the Table Style Options group.

OFFICEPRO, Inc.

Page 27