Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016



S TEP - BY -S TEP Change Table Style Options.

Steps

Practice Data

1. Select a cell in the table.

Click cell D4

The cell is selected and the Design tab appears on the Ribbon .

2. Select the Design tab.

Click Design

The Design tab is displayed.

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. Alternating colors for the data rows are turned on or turned off accordingly. 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. Alternating colors for the data columns are turned on or turned off accordingly. 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. Emphasized formatting for the first table column is turned on or turned off accordingly. 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.

Click

to

deselect it

Click

to

select it

Click

to

select it

Click

to

select it

Emphasized formatting for the last table column is turned on or turned off accordingly.

Page 28

OFFICEPRO, Inc.