Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

NOTE You can also define a range as a table using the Table button in the Tables group on the Insert tab or by pressing [Ctrl+T] or [Ctrl+L] . Excel opens the Create Table dialog box asking you to confirm the range containing the data and whether the table has headers. It automatically applies Table Style Medium 9 to the table. You can change the Table Style at any time using the Table Styles gallery.



P ROCEDURES

1. Select a cell in the range of cells containing the data you wish to define as a table. 2. Select the Home tab. 3. Select in the Styles group. 4. Select the desired Table Style from the gallery. 5. Select or deselect the My table has headers option in the Format as Table dialog box, as appropriate. 6. Select OK.



S TEP - BY -S TEP From the Student Data directory, open TABLE.XLSX . Create a table.

Steps

Practice Data

1. Select a cell in the range of cells containing the data you wish to define as a table. The cell is selected.

Click cell D5 , if necessary

2. Select the Home tab.

Click Home

The Home tab is displayed.

3. Select the Format as Table button in the Styles group. The Table Styles gallery opens.

Click

Page 22

OFFICEPRO, Inc.