Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

I NSERTING /D ELETING T ABLE R OWS /C OLUMNS  D ISCUSSION

As you work with a table, you may need to add rows or columns within the table, instead of below or to the right of existing rows and columns. You may also need to remove rows or columns. Right-clicking a cell in the table displays a shortcut menu that contains the Insert and Delete options for making these changes.

New columns are inserted to the left of the selected cell; new rows are inserted above the selected cell. Deleting a column or row, deletes the column or row containing the selected cell. Insertions and deletions apply to the Table range only, not to the entire worksheet. A column inserted into the Table only inserts cells as far as the bottom of the Table.

Inserting a new column in the Table List

OFFICEPRO, Inc.

Page 35