Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

NOTE You can also insert or delete rows in a table by clicking the arrow on the right-hand part of the Insert or Delete button in the Cells group on the Home tab to display the Insert or Delete menu. When a table cell is selected, these menus offer options for inserting or deleting table columns and table rows.



P ROCEDURES

1. Right-click a cell in the Table where you want to insert or delete a row or column. 2. To insert a column or row, point to Insert . To delete a column or row, point to Delete . 3. Select the desired option from the submenu.



S TEP - BY -S TEP Insert and delete table columns and rows.

Steps

Practice Data

1. Click into the first column after the Table. The cell is selected. 2. Type into an adjacent column. The text is showing in the cell.

Click into Cell: I3

Type the word: Profit

3. Press Enter.

Press [ Enter ]

A new column is showing in the Table

Notice that the entire column is formatted the same as others in the Table List.

As an alternative, you can always click into the Table and right-click to Insert a new Row or Column.

Page 36

OFFICEPRO, Inc.