Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016



P ROCEDURES

1. Select a cell in the table. 2. Select the Design tab. 3. Select the More button to the right of the Quick Styles gallery in the Table Styles group. 4. Select the desired table style.



S TEP - BY -S TEP

Change the Table Style.

Steps

Practice Data

1. Select a cell in the table.

Click cell B7

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. Select the More button to the

Click

right of the Quick Styles gallery in the Table Styles group. The Table Styles gallery opens.

4. Select the desired table style.

Scroll as necessary and click Table Style Dark 3

The selected style is applied to the table.

Practice the Concept: Scroll up 5 rows in the Quick Styles gallery and select Table Style Medium 12.

C HANGING T ABLE S TYLE O PTIONS  D ISCUSSION

Excel provides options that allow you to make additional changes to the Table Style. When you enable or disable these options, the styles displayed in the Table Styles gallery change accordingly.

Many of the styles in the Table Styles gallery apply banding to the table rows, you can turn off this option so that all the data rows appear in the same color. Similarly, you can turn on column banding so that alternate columns appear in a darker color.

Page 26

OFFICEPRO, Inc.