Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

NOTE Although you can change the name of a table at any time, if you have created macros that reference a table and then change the table name, you will also have to edit your macros. For this reason, it is better to apply descriptive names to your tables when you first create them.



P ROCEDURES

1. Select a cell in the table. 2. Select the Design tab. 3. Select the Table Name box in the Properties group. 4. Enter the desired name for the table. 5. Press [Enter] .



S TEP - BY -S TEP

Change a table name.

Steps

Practice Data

1. Select a cell in the table.

Click cell E6

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 Table Name box in the Properties group. The existing table name is selected. 4. Enter the desired name for the table. The new name replaces the existing text.

Click the Table Name box in the Properties group

Type RepSales

5. Press [Enter] .

Press [Enter]

The new name is applied to the table.

Page 24

OFFICEPRO, Inc.