Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Steps

Practice Data

4. Select the desired Table Style from the gallery. The desired style is selected, the gallery closes and the Format as Table dialog box opens with the range of consecutive cells around the current cell selected as a suggested range for the table. 5. Select or deselect the My table has headers option in the Format as Table dialog box, as appropriate. The My table has headers option is selected or deselected accordingly. The Format as Table dialog box closes, the selected Table Style is applied to the table, Filter arrows appear at the top of each column in the table, the Table Tools contextual Design tab appears on the Ribbon and the table range is selected. 6. Select OK .

Click Table Style Medium 9 (2nd option, second row in the Medium section of the gallery)

Click My table has headers to select it, if necessary

Click

Click on a cell outside the table to deselect it. Notice that the Design tab disappears. Click on a cell within the table. Notice that the Design tab appears.

C HANGING THE T ABLE N AME  D ISCUSSION

When you define a range as a table, Excel automatically assigns a name to the table, such as Table1 , Table2 , and so on in sequence. You can use this name in formulas and macros to reference the table. If you apply a more descriptive name to the table, you will find it easier to identify the correct table in a workbook that contains more than one table. Formulas and macros that reference the table will also be more meaningful.

OFFICEPRO, Inc.

Page 23